Today at work, I had the chance to configure a brand new HP ProLiant ML350 G5 server.
The machine came with Microsoft’s latest flavor of server operating systems, Windows Server 2008.
Windows Server 2008 installation was really fast and easy, reminding of Windows Vista setup.
When time came to install SQL Server 2005 the first real problem with Windows Server 2008 has emerged.
The SQL Server 2005 edition was the Workgroup edition, but I suppose that the Standard edition would most probably have the same problem.
When starting the installation of SQL Server, there was a prompt saying that this piece of software was incompatible with the operating system.
However, the installation could continue, and all setup options were selected and successfully installed.
According to Microsoft, SQL Server 2005 requires Microsoft SQL Server 2005 Service Pack 2 (SP2) to run on Windows Server 2008 and Windows Vista SP1. And the full release version of SQL Server 2005 has to be first installed before the SP2 can be applied.
Thus, the next step was to install SQL Server 2005 SP2.
Installation of SP2 was successful, but no SQL Server Services existed, and no database engine has been installed.
A quick Google search pointed to a Microsoft’s Knowledge Base page, KB950636, and a potential hotfix.
And this hotfix must have saved the day!
After the installation of the hotfix, SQL Server 2005 was uninstalled, and server rebooted.
Started the SQL Server 2005 for a second time, and this time, more setup options were available.
Also the wizard for the database configuration appeared, which was a good sign, as it wasn’t present on the first attempt.
Finished, applied SP2, and this little adventure ended successfully.
SQL Server 2005 was then working just fine.
Hello…
I would like to ask you, which SQL server edition that you installed? Was it Enterprise Edition? or Developer edition? or else?
Thank you for your reply.
Best regards,
-vith-
It was the “Workgroup Edition”.
Had exactly the same issue installing MSSQL 2005 (Standard) on Win server 2008 – the hot fix worked for me as well – Thanks for the posting – saved me hours of head scratching
Not working for me. Windows 2008 Standard Edition, SQL 2005 WorkGroup Edition. I just did a clean install of Windows 2008. At what point did you run the hot fix? I installed SQL, then SP2, then tried to run the hot fix and got a message that the hot fix did not apply to my system. This hot fix appears to be for Windows 2008 Webserver Edition only.
I had the Windows Server 2008 Standard Edition. This page says that it is for Windows Server 2008: http://www.microsoft.com/downloads/details.aspx?FamilyID=fb0ee17e-96eb-4cbb-ac09-95a4dcf73077&DisplayLang=en
Could it be that you have downloaded the wrong version in terms of 32/64 bits?
[...] (talked about here http://decoding.wordpress.com/2008/04/18/how-to-install-sql-server-2005-on-windows-server-2008/) [...]
My problem is the installation of SQL Server 2005 Reporting Service. I have installed the Web service and Application Service on my computer which run Windows 2008 Standard. And, I have also applied the patch KB950636 but I’m still getting the error that IIS is not detected. WWW service is running. I have created a test site to check that.
Any idea? is there a sequence to follow? the patch was applied first and the Web service role added next. That can be the cause?
help please
How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008:
http://support.microsoft.com/kb/938245/
Thank you!! This was such a time saver and extremely useful article. I actually found this before the MS kbase article.
Just thought I would thank you for posting this. I have not followed your path yet to the hot fix but I am sure this will solve my problem.
Paul
New installation windows 2008 std and this hotfix allowed me to properly install SQL 2005 STd on it. Before HotFix I had Error 1625 on Support Files Setup
Plz send me the pdf for installation of .net 2008 and sqlserver2005 with (management studio) compulsory sent to my mail kittu07_babu@yahoo.co.in
I have installed SQL Server 2005 x64 bits on Windows Server 2008. It has allowed the installation of the configuration tools but I do not have the Studio Management installed. I have installed the Service Pack 2 as well, however, Studio Management is still NOT installed
The Studio Management tool usually has to be selected for installation during the setup procedure.
I am installing SQL 2005 Standard on a Windows 2008 Enterprise Failover Cluster. No Joy. I haven’t worked with Cluster before, so it’s been a learning experience to say the least. What server roles/features do you recommend I install? When I install SQL, should I build an empty Service or an empty Distributed App Service?
I also see no Studio Management suite, and there is definitely no option to install it during set-up.
Hrmm, Im having the ‘The update does not apply to your system’ error as well. Do you have to install SQL 2005 first and have it ‘fail’ before installing the update?
Same issue here
The hotfix does not apply to Server 2008 Standard Edition but the problem is present?! So what to do?
Anyone with a solution is welcome to raise a hand
Found the soulution for my problem. URL: http://support.microsoft.com/kb/920201
Normally I would never allow a IIIS to run at my SQL Servers, but it seems to be a must with SQL 2005 – even if you don’t install SSRS SQL 2005 on Server 2008. So please read http://support.microsoft.com/kb/920201 and have a try – it might solve your problems. Take care.