SQL Server 32 Bit 2008 Upgrade on 64 Bit Server

• Kevin Jones-390730

  Newbie

  Points: 3

  More actions

  March 5, 2009 at 11:52 am

  #201030

  I am currently running SQL Server 2005 32 bit on a 64 bit server. I would like to upgrade to SQL Server 32 bit on the same server and am not having any luck. Originally I tried installing a named instance on the server and that worked but I realized that it installed SQL Server 2008 64 bit. I uninstalled that and now am trying to install SQL Server 2008 32 bit (so I can upgrade my 2005 default instance.) I know I can't go from 2005 32 bit to 2008 64 bit without extra steps, but I don't want to go to SQL 2008 64 bit. I want to stay on 32 bit.

  I have tried running the SQL 2008 Setup Exe with the /x86 switch (trying to force it to install 32 bit mode) but when I do that it tells me that there aren't any existing 2005 instances that can be upgraded.

  What am I doing wrong? Is it possible to go from 2005 32 bit to 2008 32 bit on a 64 bit server?

  Kevin

• Mohit K. Gupta

  SSChampion

  Points: 12130

  More actions

  March 5, 2009 at 2:18 pm

  #954416

  You should be able to according to ..

  http://msdn.microsoft.com/en-us/library/ms143393.aspx

  Did you have look at ...

  http://msdn.microsoft.com/en-us/library/ms144267.aspx

  Confirm your edition and product information on current install:

  SELECT ServerProperty('Version'), ServerProperty('ProductLevel'), ServerProperty('Edition')

  Thanks.. Mohit.

  [font="Arial"]---

  Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
  Microsoft FTE - SQL Server PFE

  * Some time its the search that counts, not the finding...
  * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

  How to ask for help .. Read Best Practices here[/url].