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 :)