December 6, 2014 at 11:04 pm
Hi there,
I have a 64 bit os with a 32 bit 2005 ss and wanted to upgrade it to 2008 r2. After seeking advice I've installed the 64 bit 2008 r2. However when I selected upgrade from the 2005 from the installation centre and it went through the install process and told me it was a success it hasn't upgraded 2005?
Both are express with advanced services.
Is it something to do with this WOW64 thing? Or is this just saying 2005 can be installed on a 64 bit machine. This is from the Microsoft page for version and upgrades..
1This SQL Server edition can be upgraded to SQL Server 2008 R2 on the 32-bit subsystem (WOW64) of a 64-bit server. Failover Clusters are not supported in the WOW mode. If you currently have SQL Server 2000, or SQL Server 2005 failover clusters on the 32-bit subsystem (WOW64) upgrade of the failover cluster to SQL Server 2008 R2 is not supported.
I have the install summary text file as well if that would help.
thanks,
December 6, 2014 at 11:34 pm
Just an update to this. When I ran the upgrade it DIDN'T ask me to select an instance (ie the 2005 instance)
December 7, 2014 at 12:19 am
It turns out that for a ss 2005 upgrade to ss 2008 r2 on a 64 bit for EXPRESS editions you need to use the ss 2008 r2 32 bit version and not the 64 bit version.
So it's worked now.
thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply