Security Group Sid upgrade rule fails Solution

 

Problem:

SQL express 2005 upgrades SQL express 2008 and reports the following error:

 

"Security Group Sid (Security Identifier)" failed.

  

 

Solution:

1. Open Registry: C: \ WINDOWS \ regedit.exe

2. Go to the following branch: HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server \ mssql.1 \ setup

3. Create the following values:

• Name: agtgroup value: S-1-5-21-3393364855-3123648101-94765706-1006
• Name: sqlgroup value: S-1-5-21-3393364855-3123648101-94765706-1005
• Name: ftsgroup value: S-1-5-21-3393364855-3123648101-94765706-1004

(If the problem persists, go to HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server \ mssql10.sqlexpress \ setup and copy the name from the path above with the same key value .)

(* The rule is that the last one of the three values is adjacent)

4. Click the re-run button on the installation page to verify the installation again.