Tuesday, October 16, 2012

Upgrade: SQL 2005 on Windows server 2003 to SQL 2012

Environment: Windows 2003 R2 , SQL Server 2005, SSRS 2005

The fact is, SQL Server 2012 is not supported in Windows Server 2003. While we attempt to do so, we will always end up with an error message as in screenshots.

Test Server configuration

Run Setup

Error Message blocking further installation

How ever, we have many workarounds. One like,Upgrade your Windows server and then upgrade your SQL Server.... Oouch...! (is a very painful task thereafter). 
The cool way is migrate to a new server ;-)