[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:
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)
Object: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer\SuperSocketNetLib
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
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:
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: http://technet.microsoft.com/en-us/library/cc794697(WS.10).aspx .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.