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
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!
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?
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.