November 6, 2009 at 4:34 am
Has anyone actually managed to install SQL Server 2005 Standard 64bit on Windows 2008 Server Standard 64 Bit ? I mean actually done it in practice, rather just looked at the Microsoft Compatibility list ?
I have made sure the server has met all the requirements including IIS.
Everything ticked to be installed.
SP2 then installed (SP3 Now tried as well).
However only the SQL Server 2005 configuration tools appear.
I have found these posts which have a similiar issue, but they are for web server not standard:
http://decoding.wordpress.com/2008/04/18/how-to-install-sql-server-2005-on-windows-server-2008/
The fix will only install on web server 2008 not standard. Is there a fix for Windows Server 2008 Standard? Repeated on another server (spec) same issue.
November 11, 2009 at 1:28 am
Are you sure you are trying to install SQL Server 2005 Standard Edition? It almost looks like you are trying to install a web edition.
Have you checked the setup logs to see if there were any errors?
November 12, 2009 at 6:07 am
It has worked OK for me. It also works OK on W2008 R2.
You need to install Visual Studio 2003 SP1 (as documented in BOL) and SQL 2005 SP2 or SP3, and click to proceed on the Compatibility Warning messages during the initial SQL install, but otherwise it is fine.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
November 12, 2009 at 7:10 am
Why must you install Visual Studio to get SQL Server to function? I have not had to do that on my SQL 2005 installs?
November 12, 2009 at 7:37 am
You do not need to install VS 2003, just VS 2003 SP1. The SQL install loads a subset of VS2003 on to your machine. BIDS runs within Visual Studio, and needs SP1 to run OK when installed on W2008.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
November 12, 2009 at 8:01 am
Markus (11/12/2009)
Why must you install Visual Studio to get SQL Server to function? I have not had to do that on my SQL 2005 installs?
The reason is VS2005 is SQL Server 2005 BIDS and it is technically not compatible with Vista and above and the previous post is talking about VS2005 not VS2003 which actually will not install in Vista.
Kind regards,
Gift Peddie
November 12, 2009 at 8:18 am
Yes, my bad. I did mean VS 2005.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
November 12, 2009 at 8:21 am
You need to install Visual Studio 2003 SP1 (as documented in BOL) and SQL 2005 SP2 or SP3, and click to proceed on the Compatibility Warning messages during the initial SQL install, but otherwise it is fine.
I just cannot find in BOL where this is. Can someone please point out where this is in BOL.
November 12, 2009 at 8:44 am
I am trying to find the reference, I know I read it somewhere in the SQL docs...
...anyway, there are VS references that say you need SP1 to run VS2005 on W2008. This thread about installing SQL 2005 on a W2008 cluster also mentions the need for VS2005 SP1 (plus a hotfix I did not know about) http://www.sqlservercentral.com/Forums/Topic522362-146-1.aspx
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
November 12, 2009 at 8:49 am
EdVassie (11/12/2009)
I am trying to find the reference, I know I read it somewhere in the SQL docs......anyway, there are VS references that say you need SP1 to run VS2005 on W2008. This thread about installing SQL 2005 on a W2008 cluster also mentions the need for VS2005 SP1 (plus a hotfix I did not know about) http://www.sqlservercentral.com/Forums/Topic522362-146-1.aspx
VS2005 is technically not compatible with Vista that is the reason for VS2005 SP1 requirement with all operating systems of Vista and up. But I am running one in Windows 7 ultimate just ignore the warning.
Kind regards,
Gift Peddie
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply