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

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

TL;DR; 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?

Smart Classifications

Each classification [Concepts, Categories, & Tags] was assigned using AI-powered semantic analysis and scored across relevance, depth, and alignment. Final decisions? Still human. Always traceable. Hover to see how it applies.

Subscribe

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.​

ProgramUtvikling Logo

ProgramUtvikling

Emerson Process Management Logo

Emerson Process Management

Trayport Logo

Trayport

NIT A/S

Xceptor - Process and Data Automation Logo

Xceptor - Process and Data Automation

Flowmaster (a Mentor Graphics Company) Logo

Flowmaster (a Mentor Graphics Company)

Boxit Document Solutions Logo

Boxit Document Solutions

Epic Games Logo

Epic Games

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.

Milliman Logo

Milliman

Capita Secure Information Solutions Ltd Logo

Capita Secure Information Solutions Ltd

Big Data for Humans Logo

Big Data for Humans

Ericson Logo

Ericson

Teleplan Logo

Teleplan

Schlumberger Logo

Schlumberger

Lockheed Martin Logo

Lockheed Martin

Sage Logo

Sage

Genus Breeding Ltd Logo

Genus Breeding Ltd

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Ghana Police Service Logo

Ghana Police Service

Royal Air Force Logo

Royal Air Force

Nottingham County Council Logo

Nottingham County Council

Washington Department of Transport Logo

Washington Department of Transport

Washington Department of Enterprise Services Logo

Washington Department of Enterprise Services

Philips Logo

Philips

Workday Logo

Workday

Teleplan Logo

Teleplan

Genus Breeding Ltd Logo

Genus Breeding Ltd

ALS Life Sciences Logo

ALS Life Sciences

Milliman Logo

Milliman