Thursday, 5 March 2009

Installing SQL Server Express 2005 on Windows 2008 SBS

Due to what frankly seems to be a complete botch from Microsoft SQL Server Express 2005 can be a pain to get installed on Windows Server 2008 SBS.



Installing SQL Server 2005
If you plan to install SQL Server 2005 on the original server running Windows SBS 2008, do the following before you run the installation.

  • Click Start, click All Programs, click Accessories, and then click Run.

  • Type regedit, and then click OK.

  • At the User Account Control prompt, click OK.

  • Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90.

  • Double-click OriginalMachineName, and then change the OriginalMachineName value name to the current server name.

  • Click OK.

No comments: