SQL 2005 on Server 2008
-
Monday, March 04, 2013 4:14 PM
We are building a new server which is currently 2003 data center with SQL 2005. The app team and DB team would like to keep everything the same. I would like to use 2008 R2 as the OS. This wil be an active/passive cluster.
Which is the better option:
1) install SQL 2005 on 2008 R2 and address known issues with SQL 2005 on server 2008 R2.
2) install SQL 2005 on 2003 data center, keep everything the same, no new issues or workarounds.
Thanks,
Paul
All Replies
-
Monday, March 04, 2013 4:37 PMModerator
Hello,
I would choose to install SQL Server 2005 (with SP3 or SP4) on Windows Server 2008 R2. This way you have the operating system ready to support a future upgrade of SQL Server. Windows Server 2003 is not supported anymore.This is assuming that you not migrating from x86 to x64.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Monday, March 04, 2013 5:00 PM
Are the issues documented in this KB "List of known issues when you install SQL Server 2005 on Windows Server 2008" significant? Do the workarounds work?
BTW, extended support for 2003 is 2 more years.
Thanks,
Paul
-
Monday, March 04, 2013 5:51 PMModerator
Hello,
Please read the following resources about know issues:
http://support.microsoft.com/kb/955725
http://support.microsoft.com/?kbid=960320http://blogs.msdn.com/b/petersad/archive/2009/01/15/sql-server-sp3-has-compatibility-issues-on-vista-and-windows-2008.aspx
"FIX: In SQL Server 2005, the DTS designer application cannot be started on a Windows Vista-based computer or on a Windows Server 2008-based computer"
http://support.microsoft.com/kb/955706
Extended support of Windows Server 2003 Datacenter ends on July 2015 (and this guarantee security fixes only), but mainstream support ended on 2010. Only if you have enrolled on the Extended Hotfix Support program you will receive from Microsoft non-security hotfixes.
http://blogs.technet.com/b/windowsserver/archive/2009/09/15/support-changes-coming-july-2010-for-windows-2000-server-and-windows-server-2003.aspx
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com- Proposed As Answer by Ahmed Ibrahim - MSFTMicrosoft Employee, Moderator Tuesday, March 05, 2013 10:43 AM
- Marked As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Monday, March 11, 2013 5:52 AM
-
Tuesday, March 05, 2013 10:44 AMModeratorI would second Alberto's suggestion regarding installing the latest service pack.
FAQ
----
Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.
.png)
