TFS 2012 - Issue: Manage Group Membership missing from admin after TFS 2008 to TFS 2012 Upgrade
Explains how to restore missing group membership management in TFS 2012 after upgrading from TFS 2008 by manually adding permissions using TFS …
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.
When running the installer for TFS 2012 you get an TF255507 error with the following error message.
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
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”.
Rename your server before you install SQL.
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
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?
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.
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.
We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.
Milliman
Workday
Teleplan
Boeing
Graham & Brown
Hubtel Ghana
Freadom
DFDS
Kongsberg Maritime
Emerson Process Management
Schlumberger
Lockheed Martin
New Signature
Jack Links
Genus Breeding Ltd
Bistech
Epic Games
Higher Education Statistics Agency
Washington Department of Transport
Royal Air Force
Ghana Police Service
New Hampshire Supreme Court
Nottingham County Council
Washington Department of Enterprise Services
Slaughter and May
Workday
Illumina
New Signature
Graham & Brown
Brandes Investment Partners L.P.