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.

See:
http://technet.microsoft.com/en-us/library/cc794697.aspx

Especially:

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: