Archive for March, 2013
TF255507: The security identifier (SID) for the following SQL Server login conflicts with a specified domain or workgroup account
When I was configuring the TFS 2010 after completing the installation, I have got the following error message!
This is the brief error message and you can see the details results and solution here
"TF255507: The security identifier (SID) for the following SQL Server login conflicts with a specified domain or workgroup account"
Basically the workgroup account I have choosen to host the TFS databases ( SP2010\STEPBISTEPSQL) is SP2010\Administrator but the original SQL server login account is WIN-5DWGQLQJNRV\Administrator so both conflicting!
To solve this issue, we need to rename the conflicts login and we will see the steps below!
Solution 1: Open the command prompt and type the following command and then hit Enter key!
“sqlcmd -E -S “””
Actually this command is altering the login id with the correct account.
Solution 2: Add the account using the SQL server UI! Open the SQL server and select the Security–>Logins, you could see the conflict login id, just remove this id.
Right click on the logins and then select the New Login..
You will get the following window, enter the Login name and hit OK
That’s all, we are good to go! Here is the renamed login screen!
Installing Visual Studio Team Foundation Server 2010 (TFS 2010) is pretty simple, there are few types of installation available in TFS 2010/2012, they are:
- Standard Single Server
- Advanced-Tier only
In this installation, I am going to choose the basic installation right now (TFS 2010) and I will post the advanced installation (in TFS 2012) later! 🙂
1. Double click the Setup.exe OR tfs_server.exe in your installation media!
2. You will get the following screen after few seconds, click Next
3. Select the license term and click Next
4. Select the necessary features and installation path then click install button.
5. Installation in progress
6. Few minutes later, you will get the following Success screen! 🙂
Select the Launch TFS Configuration Tool check box, and then click Configure button! I will post other screens tomorrow! 🙂