13Aug/080
Installing Microsoft Sql Server 2005 x64 on Microsoft Windows Server 2008 x64
These are some issues I've ran into, and their solutions:
- You might stop on the compatibility check saying there is no IIS. The problem here is that you need a certain set of role services installed, including the II6 compatibility services.
- You might stop on a message saying "SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system." - the problem is that the SQL installer does not expect the Windows Web Server 2008 licensing information. Hotfix here.
- If you supply a Local or Domain Account, you might get problems with the service not starting, and install failing. Be sure it has the right permissions, or just install as 'Local System' to get things up and running, then change the service settings afterward - but be sure to do it thru the SQL Server Configuration Manager, as the account needs additional acl and policy permissions.
- Be sure to apply the latest Service Pack directly after installation.
- And by all means, be sure you have your firewall settings in order; SQL server runs on TCP 1433.