I wanted to take a look at writing SQL Reports for TFS. I was going to install the Business Intelligence Studio for SQL Server 2005 but I thought it would be better to use the latest edition of SQL Reporting Services in SQL Server 2008. So I decided to upgrade my TFS Test Server to SQL Server 2008. This is a single server install of TFS. I ran the SQL Server 2008 Upgrade Wizard. Most of the steps were straight-forward. I only ran into one roadblock that I was able to fix and I documented below. Here’s the steps.
First I chose the “Upgrade from SQL Server 2000 or SQL Server 2005” option.
I kept the default settings for all of the steps except when it asked what instance I would like to upgrade.
All of the checks passed but one. I got the following error.
Rule "Security Group SID (Security Identifier)" failed.
http://go.microsoft.com/fwlink/?LinkId=94001
I went to the link but it didn’t help. I searched on the web for for the error and I found the fix here. Basically I had to manually replace the invalid SIDs with the new one.
To find the correct SIDs, I ran the command prompt utility: whoami /groups
If you have multiple editions of SQL Server installed make sure you are in the correct one in the registry. Look at the Edition key
I pasted the correct SIDs into the registry keys
I fixed the ones in MSSQL.2 but I was still getting the error. I checked the log file %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LOG\Detail.txt and here is the error.
2009-04-14 23:24:25 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.3\Setup
2009-04-14 23:24:25 Slp: SqlSidRule.GetSidValue - reading value name ASGroup
2009-04-14 23:24:25 Slp: Sco: Attempting to get registry value ASGroup
2009-04-14 23:24:25 Slp: Sco: Attempting to get account from sid S-1-5-21-3621347759-1475631895-1437307089-1014
2009-04-14 23:24:25 Slp: Sco: LookupAccountSid failed for SID S-1-5-21-3621347759-1475631895-1437307089-1014
2009-04-14 23:24:25 Slp: SqlSidRule.EnsureGroupExists - Exception caught and ignored. Returning false. Exception message is No mapping between account names and security IDs was done.
I grabbed the SID for the ASUser and it worked!
The wizard continued and finished. I launched Visual Studio and TFS is working properly.
Now I can look at the SQL Reporting :)