2 instances of SQL Server?

lee88
lee88 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AneeshDatabase Consultant
Top Expert 2009

Commented:
try uninstalling sql 2005, it will ask for the instance to uninstall in another step
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
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..
If you're not experiencing any performance issues, I would suggest leaving things alone.  If you want to disable an instance for SQL Server, then more than likely you could disable SQLEXPRESS.  Simple disable the context before performing any uninstall to ensure none of your applications are affected.  I would imagine ACT7 supports your ACT Sales data.
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial