Saturday, September 28, 2013

Remove a named instance in SQL Server 2008/2012

If you have two instances of SQL Server installed in your desktop and want to remove one of the instances then follow these steps:

1. Go to “Control Panel” and select “Add/Remove Programs” or “Uninstall Programs”.

2. Select “SQL Server Management Studio” in the installed products.

3. Do not get scared when you click “Remove” button it will not install all the instances. When it asks for the instance name to select from the list of instances, select the instance to be deleted.

4. Click “Next” till all the steps are completed.