Unable to install SQL Server Developer R2 on Windows XP SP2 OS with previous installation SQL Server 2008

Question

Hi,

I am trying to install SQL Server 2008 Developer R2 on Windows XP SP2 . I had SQL Server 2008 previously installed which expired. I have deleted previous default instances of SQL Server Register keys manually.

 After the installation failed , it gave the following error mesage in log file - "Specified instance {B5153233-9AEE-4CD4-9D2C-4FAAC870DBE2} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed."

I found a similar post with above mentioned installation error in site

http://connect.microsoft.com/SQLServer/feedback/details/355756/rc0-setup-fails-with-1639-when-installing-a-new-default-instance-on-a-server-with-previous-uninstall-of-sql-2005

As they said in there site to run the command "msiexec /I {FBD367D1-642F-47CF-B79B-9BE48FB34007} REMOVE=ALL  , i ran but it gave this message "This action is not valid for products that are currently installed".

How do I fix this problem? I have to complete SQL Server 2008 installation by today.

Thanks,

Lavanya

 

 

 

Answer 1

This for sure talks about leftovers with your previous installation. Please be aware of the fact that removing/deleting keys from registries might be harmful for your Server..

Refer:

• http://blogs.msdn.com/b/sqlserverfaq/archive/2009/06/13/upgrade-from-sql-2005-to-sql-2008-might-fail-with-msigetproductinfo-error.aspx
• http://social.msdn.microsoft.com/Forums/en-IE/sqlsetupandupgrade/thread/4784f44d-92b6-45aa-a525-7bdca3d2374e

 

Try Prashant's suggestion by removing the product code from the location : HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products

This can help you!!

Note: This post should not be treated as the Microsoft’s Recommendation or Resolution to the problem, it is only a workaround which worked in an environment.

 

 

Hope this helps... 

---

Chaitanya( Twitter | Blogs )

Answer 2

Thanks Chaitanya for the reply.

As Prashant suggested to remove that product code HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\C31EAFF906160DD46AA7AD5C99F418DB from registry , I didnot find that product code in my system registry.

So during SQL Server installation instead of trying with new default instance , i tried with a different new named instance , now its giving new error -
Cannot find service {0}, Parameter name: MSSQLServerADHelpher100.
How do I know MSSQLServerADHelpher100 service is installed in my system. If its not , how do I install it?

Thanks,
Lavanya

 

Answer 3

Hello,

Try the following procedures to uninstall SQL Server 2008 R2 manually:

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/8e368d8d-a008-44d6-9169-b9aeaa6b53b7 (Grace Liu)

Please install XP SP3 also. It is required for SQL Server 2008 R2 Developer Edition 32-bit.

http://msdn.microsoft.com/en-us/library/ms143506.aspx#Developer32

Regards,

Alberto Morillo
SQLCoffee.com

 

Answer 4

Check these: http://support.microsoft.com/kb/955493, and http://support.microsoft.com/kb/955404/en-us

Also, for sure there are some left overs in the registries during your attempt to uninstall the existing instances multiple times.

To resolve the issue happened in the installation, there is a verbose Detail.txt log file indicated in the summary logs, please post that log file here. Another way to solve this issue is uninstalling previous SQL Server setups manually.

More information about uninstall SQL Server:

SQL Server 2008 installation fails when you try to install SQL Server a second time

How to: Uninstall an Existing Instance of SQL Server (Setup)

If you have already tried the above steps, check the following posts, that have registries to be cleaned up in case of SQL Server 2008: http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/3974daa9-9da1-46d9-8001-57b8517d3470?prof=required

looks like cleaning up of left overs is mandatory in your case, as there seems to be some entries still existing on your machine..

Hope this helps.

---

Chaitanya( Twitter | Blogs )