a·gen·tic a·gil·i·ty

TFS 2012 Issue: TF255507: The security identifier (SID) for the following SQL Server login conflicts

Explains how to resolve the TF255507 SID conflict error in TFS 2012 caused by server renaming, including SQL commands to fix login issues in SQL Server 2012.

Published on
2 minute read
Image
https://nkdagility.com/resources/xEMKWWn-mv3
Subscribe

Issue

When running the installer for TFS 2012 you get an TF255507 error with the following error message.

TFS 2012 Issue: TF255507: The security identifier (SID) for the following SQL Server login conflicts

Figure: TF255507 The security identifier (SID) for the following SQL Server login conflicts

If you look in the log file you will see a little additional information:

 1[Info   @22:29:03.647] +-+-+-+-+-| Running Verify Admin login: Verifying that the given account does not already have a SQL login that is denied access or with the wrong SID |+-+-+-+-+-
 2[Info   @22:29:03.647]
 3[Info   @22:29:03.647] +-+-+-+-+-| Verifying that the given account does not already have a SQL login that is denied access or with the wrong SID |+-+-+-+-+-
 4[Info   @22:29:03.647] Starting Node: VSQLLOGIN
 5[Info   @22:29:03.647] NodePath : VINPUTS/Progress/Conditional/VSQLNOTLOCALDB/VSQLISRUNNING/VSQLCONNECT/VSQLLOGIN
 6[Info   @22:29:03.647] Verifying SQL login of account KRAKENAdministrator does not exist on Kraken, or if it exists, it does not have a different SID and it is not denied access to the server.
 7[Info   @22:29:03.694] Node returned: Error
 8[Error  @22:29:03.694] TF255507: The security identifier (SID) for the following SQL Server login conflicts with a specified domain or workgroup account: WIN-EO45N4FNSOCAdministrator. The domain or workgroup account is: KRAKENAdministrator.  The server selected to host the databases for Team Foundation Server is: Kraken.
 9You can resolve this issue by renaming the conflicting login. To do so, open a command prompt on the computer that is running SQL Server and execute the following command:
10sqlcmd -E -S "Kraken" -Q "ALTER LOGIN [WIN-EO45N4FNSOCAdministrator] WITH NAME = [KRAKENAdministrator]"
11For more information, see the following page on the Microsoft Web site: http://go.microsoft.com/fwlink/?LinkId=183408

Figure: Error from log

Applies To

Findings

It looks like the Server was renamed after the install of SQL Server 2012. The original generated name was “WIN-EO45N4FNSOC” and it was subsequently renamed to “KRAKEN”.

Solution 1

Rename your server before you install SQL.

Solution 2

As specified in the error message you need to run the SQL Command to fix. Alternatively you could just remove and add the correct account. However altering the account will maintain any audit trail.

1sqlcmd -E -S "Kraken" -Q "ALTER LOGIN [WIN-EO45N4FNSOCAdministrator] WITH NAME = [KRAKENAdministrator]"

Figure: Run this on the SQL Server to fix

TFS 2012 Issue: TF255507: The security identifier (SID) for the following SQL Server login conflicts

Figure: Rerun Readiness Checks

Once you have run the command you can “rerun Readiness Checks” to clear out the error.

Did this fix your problem?

Install and Configuration Troubleshooting Windows System Configuration
Subscribe

Related Blog

No related videos found.

Connect with Martin Hinshelwood

If you've made it this far, it's worth connecting with our principal consultant and coach, Martin Hinshelwood, for a 30-minute 'ask me anything' call.

Our Happy Clients​

We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.​

Emerson Process Management Logo

Emerson Process Management

Jack Links Logo

Jack Links

Bistech Logo

Bistech

CR2

Genus Breeding Ltd Logo

Genus Breeding Ltd

Boeing Logo

Boeing

Schlumberger Logo

Schlumberger

Lean SA Logo

Lean SA

Trayport Logo

Trayport

Illumina Logo

Illumina

Epic Games Logo

Epic Games

Slaughter and May Logo

Slaughter and May

Akaditi Logo

Akaditi

ProgramUtvikling Logo

ProgramUtvikling

SuperControl Logo

SuperControl

Microsoft Logo

Microsoft

YearUp.org Logo

YearUp.org

Sage Logo

Sage

Ghana Police Service Logo

Ghana Police Service

Washington Department of Transport Logo

Washington Department of Transport

Washington Department of Enterprise Services Logo

Washington Department of Enterprise Services

Nottingham County Council Logo

Nottingham County Council

Royal Air Force Logo

Royal Air Force

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

Sage Logo

Sage

Bistech Logo

Bistech

Milliman Logo

Milliman

Kongsberg Maritime Logo

Kongsberg Maritime

YearUp.org Logo

YearUp.org

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.