x

SQL2008R2 on Windows Server 2003 SP2 32bit

We have a Development windows server 2003 SP2 32bit. On the server, it has 2 instances: SQL2000, and SQL 2008. In order to keep SQL2008 in sink with our Test & Prod environments, I like to upgrade the SQL2008 to SQL 2008R2. I kept received an error saying :

An attempt was made to install (or update) SQL Server Native Client on a computer where SQL Server Native Client is already installed, and where the existing installation was from an MSI file that was not named sqlncli.msi.

http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000⪻odVer=10.50.1600.1

So I decided to install a new instance SQL2008R2, and if it works, I just removed the SQL2008. But I still received the same error.

Is it possible to install a new instance SQL2008R2 on windows server 2008 SP2 32 bit?

Please advice.

Thanks Ta
more ▼

asked Apr 26, 2012 at 06:16 PM in Default

dmta2005 gravatar image

dmta2005
0 1 1 1

Just a thought... Windows 2003 passed out of mainstream support nearly 2 years ago on 13 July 2010...
Apr 26, 2012 at 09:26 PM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Forgive me, but did you try to uninstall the Native Client as the URL instructed and then try to upgrade?

To answer your question though, yes you can install SQL 2008 R2 on Windows 2008 SP2 32bit. I don't see a reason why you wouldn't be able to.

Hope this helps!
more ▼

answered Apr 26, 2012 at 06:40 PM

JohnM gravatar image

JohnM
6.9k 1 3 7

I just noticed that the title of the question stated Windows 2003. Just in case, you can install SQL Server 2008 R2 on Windows Server 2003 SP2 as well. Here is where you can confirm: http://technet.microsoft.com/en-us/library/ms143506%28v=sql.105%29.aspx

Apr 26, 2012 at 06:47 PM JohnM
(comments are locked)
10|1200 characters needed characters left

No, I didn't try to uninstall the current SQL2008. Should I? I was trying to create a new instance of SQL2008R2 before I remove the current SQL2008.

I meant windows server 2003 SP2 32 bit.

Is it possible to install a new instance SQL2008R2 on windows server 20038 SP2 32 bit?
more ▼

answered Apr 26, 2012 at 07:06 PM

dmta2005 gravatar image

dmta2005
0 1 1 1

You shouldn't uninstall the entire instance, just the Native Client. If you go into the control panel, you should be able to just uninstall that client and then attempt to upgrade the instance again.

Yes, you can install a new instance of 2008 R2 onto Windows 2003 SP2 32bit. You can refer to the URL that I provided in the comment to my previous answer to confirm that.

Hope this helps!
Apr 26, 2012 at 07:59 PM JohnM
(comments are locked)
10|1200 characters needed characters left

Thank you so much for replying to my question. Your suggestions gave me some ideas. I will either:

1) Uninstall the SQL2008, and install the SQL2008R2. This is just DEV environment. or 2) Talk to my boss if we can go ahead & upgrade the windows 2003 SP2 32bit to Windows 2008R2 64bits, and get rid of SQL2000 instance, and install SQL2008R2. Even though, we still some SQL2000 databases in production, but I think we still can copy them to SQL2008R2 for testing.

Ta.
more ▼

answered Apr 26, 2012 at 10:16 PM

dmta2005 gravatar image

dmta2005
0 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x587
x12

asked: Apr 26, 2012 at 06:16 PM

Seen: 8320 times

Last Updated: Apr 26, 2012 at 10:16 PM