Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Remove an SQL Server instance

A site may have multiple SQL instances, for example GALLAGHER, GALLAGHER1, or SQLEXPRESS. A default Command Centre install expects to create a GALLAGHER instance, so an existing instance can get in the way. Removing an unused instance is also useful when an instance is blocking a SQL upgrade.

Steps

  1. Extract the install files. Create a new folder under the C drive, for example C:\SQLEXPR. Run SQLEXPR_x64_ENU.exe from …\Setup\SQLInstall\ on the Gallagher install media, and set the extract path to C:\SQLEXPR\.

    Choose Directory For Extracted Files dialog with the path set to C:\SQLEXPR
  2. Remove the instance. Open a Command Prompt and move to the SQL folder:

    cd c:\SQLEXPR
    setup.exe /action="uninstall"

    Select the instance to remove and click Next.

    Remove SQL Server, Select Instance page, with the instance to remove features from chosen from the drop-down list of installed instances

    Click Select All, then click Next. Note that the SQL Client Connectivity SDK is NOT checked.

    Remove SQL Server, Select Features page, with the instance features ticked and Shared Features SQL Client Connectivity SDK left unticked

The instance is then uninstalled.

Last updated

Was this helpful?