2 instances of SQL Server?
Apparently I have 2 instances of SQL Server installed on my laptop. I'd like to uninstall one.
The one I'd like to keep is for my ACT application: "SQL Server (ACT7)"
The one I'd like to uninstall is: "SQL Server (SQLEXPRESS)"
Looking at the attached screen shot of installed programs, which program(s) should I uninstall, and in what order should I uninstall them?
Any idea why "installed programs" does not show 2 instances of SQL Server?
SQL-installed-and-services.jpg
The one I'd like to keep is for my ACT application: "SQL Server (ACT7)"
The one I'd like to uninstall is: "SQL Server (SQLEXPRESS)"
Looking at the attached screen shot of installed programs, which program(s) should I uninstall, and in what order should I uninstall them?
Any idea why "installed programs" does not show 2 instances of SQL Server?
SQL-installed-and-services.jpg
Aneesh
try uninstalling sql 2005, it will ask for the instance to uninstall in another step
Go to Control Panel --> Add \ Remove Programs and then choose SQL Server 2005 Express and uninstall it.
Aneesh's comment will hold good if you have two instances of a single edition..
Aneesh's comment will hold good if you have two instances of a single edition..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The resolution to remove multiple database engine instances from Microsoft SQL Server 2005 is to install ARPWrapper.exe again after removing each components. The following guide provides step-by-step instructions on how to uninstall stand-alone or multiple instance of SQL Server 2005 manually.
1.Login to the server with an administrator user account, or SQL Server 2005 service account.
2.Stop all active SQL Server services in Services applet in Control Panel as any active connections may prevent the uninstallation process from finishing successfully.
3.Go to Control Panel and then Add or Remove Programs applet.
4.Search and verify that Microsoft SQL Server Setup Support Files appears in the list of installed programs. If its found, proceed to next step. If Microsoft SQL Server Setup Support Files component is not listed as one of the installed program, install the component by running sqlsupport.msi file locates in Servers\setup\ folder of the original SQL Server 2005 installation media, or disc, folder and USB flash drive that contains SQL Server 2005 setup files.
5.Open command prompt (in Vista, use command prompt with administrator rights), and run the following command to uninstall the SQL Server components:
%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove
6.Uninstall the SQL Server instance components such as database engine one at a time.
refer the image attached
7.Once the removal completes, repeat all of the above steps again until all the SQL Server components are uninstalled.
8.Finally, uninstall the Microsoft SQL Server Setup Support Files component by using Add or Remove Programs (It should has been removed, but double check to ensure that).
Above guide assumes that you didnt encounter any other problems, and simply want to get rid of all DB instances of the SQL Server 2005. If you have other issues, refer to KB909906 on how to manually uninstall SQL Server.
remove-sql-2005.jpg
1.Login to the server with an administrator user account, or SQL Server 2005 service account.
2.Stop all active SQL Server services in Services applet in Control Panel as any active connections may prevent the uninstallation process from finishing successfully.
3.Go to Control Panel and then Add or Remove Programs applet.
4.Search and verify that Microsoft SQL Server Setup Support Files appears in the list of installed programs. If its found, proceed to next step. If Microsoft SQL Server Setup Support Files component is not listed as one of the installed program, install the component by running sqlsupport.msi file locates in Servers\setup\ folder of the original SQL Server 2005 installation media, or disc, folder and USB flash drive that contains SQL Server 2005 setup files.
5.Open command prompt (in Vista, use command prompt with administrator rights), and run the following command to uninstall the SQL Server components:
%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove
6.Uninstall the SQL Server instance components such as database engine one at a time.
refer the image attached
7.Once the removal completes, repeat all of the above steps again until all the SQL Server components are uninstalled.
8.Finally, uninstall the Microsoft SQL Server Setup Support Files component by using Add or Remove Programs (It should has been removed, but double check to ensure that).
Above guide assumes that you didnt encounter any other problems, and simply want to get rid of all DB instances of the SQL Server 2005. If you have other issues, refer to KB909906 on how to manually uninstall SQL Server.
remove-sql-2005.jpg