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.
Monday, March 04, 2013 4:37 PMModerator
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.
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.
Monday, March 04, 2013 5:51 PMModerator
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.
Hope this helps.
Tuesday, March 05, 2013 10:44 AMModeratorI would second Alberto's suggestion regarding installing the latest service pack.
SQL Server Setup Team
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.