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

Milliman Logo

Milliman

Workday Logo

Workday

Teleplan Logo

Teleplan

Boeing Logo

Boeing

Graham & Brown Logo

Graham & Brown

Hubtel Ghana Logo

Hubtel Ghana

Freadom Logo

Freadom

DFDS Logo

DFDS

Kongsberg Maritime Logo

Kongsberg Maritime

Emerson Process Management Logo

Emerson Process Management

Schlumberger Logo

Schlumberger

Lockheed Martin Logo

Lockheed Martin

New Signature Logo

New Signature

Jack Links Logo

Jack Links

Genus Breeding Ltd Logo

Genus Breeding Ltd

Bistech Logo

Bistech

Epic Games Logo

Epic Games

Higher Education Statistics Agency Logo

Higher Education Statistics Agency

Washington Department of Transport Logo

Washington Department of Transport

Royal Air Force Logo

Royal Air Force

Ghana Police Service Logo

Ghana Police Service

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Nottingham County Council Logo

Nottingham County Council

Washington Department of Enterprise Services Logo

Washington Department of Enterprise Services

Slaughter and May Logo

Slaughter and May

Workday Logo

Workday

Illumina Logo

Illumina

New Signature Logo

New Signature

Graham & Brown Logo

Graham & Brown

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.