question

dmta2005 avatar image
dmta2005 asked

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&ProdVer=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
sql-server-2008-r2windows-2003
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Just a thought... Windows 2003 passed out of mainstream support nearly 2 years ago on 13 July 2010...
0 Likes 0 ·
JohnM avatar image
JohnM answered
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!
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
0 Likes 0 ·
dmta2005 avatar image
dmta2005 answered
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?
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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!
0 Likes 0 ·
dmta2005 avatar image
dmta2005 answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.