Error While Installing SQL 2005 Express on SBS 2008

[Today's post comes to us courtesy of Justin Crosby, Shawn Sullivan, and Mohammed Sabir Chandwale]

You may receive the following error when trying to install SQL Server 2005 on an SBS 2008 server:

image

Microsoft SQL Server 2005 Setup

SQL Server Setup failed to modify security permissions on the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#\MSSQLServer\SuperSocketNetLib for user <username>.

You will also notice the following entries in the SQL setup log (C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup000#_ServerName_SQL.txt)

Configuring ACL:
  Object: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer\SuperSocketNetLib
  ACL:    (A;CI;KR;;;[SQLServer2005SQLBrowserUser$WIN-EUGSO7LO7PY])(A;CI;KR;;;SY)
Action:  0x100

Failed ACL:
  ReplaceSDDLSid is failed at the error code 1332; Converted SDDL: '(A;CI;KR;;;[SQLServer2005SQLBrowserUser$WIN-EUGSO7LO7PY])(A;CI;KR;;;SY)'
        Error Code: 0x80077344 (29508)
Windows Error Text:   Source File Name: sqlca\sqlsddlca.cpp
Compiler Timestamp: Tue Sep 13 01:08:29 2005
     Function Name: ExceptionInSDDL
Source Line Number: 65

Resolution

Once you get this error you must click Abort to cancel and rollback the SQL installation. Once SQL install finishes the rollback you must make the following registry change:

  1. Click Start, click All Programs, click Accessories, and then click Run.
  2. Type regedit, and then click OK.
  3. At the User Account Control prompt, click OK.
  4. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Machines.
    image
  5. Double-click OriginalMachineName, and then change the OriginalMachineName value name to the current server name. (An easy method to find the current server name is to use the hostname command from a command prompt.)
    image
  6. Click OK.

Once this registry key has been updated you should be able to install SQL 2005 without error.  We recommend that you install your LOB applications and SQL instances on the 2nd server included with SBS 2008 Premium for best performance.

For more information please see: https://technet.microsoft.com/en-us/library/cc794697(WS.10).aspx.