You need to remove the SQL instance for troubleshooting or no longer need it. How do you uninstall that instance without disturbing other instances or causing SQL to get stuck?
It is very important that you follow these steps exactly and do not skip any steps. Skipping steps risks getting the SQL instance stuck on the system (requiring removal via registry keys) and causing BarTender to crash unexpectedly.
Removing BarTender and SQL
- Uninstall BarTender and deactivate it using the Control Panel.
- Restart the system.
- Locate Microsoft SQL Server 2014 (64-bit) or (32-bit) on the Programs and Features list.
- If you installed their own SQL version or the SQL instance is originally from a different version than BarTender 2019, the year listed here may be different.
- Select it and click "Uninstall/Change"
- Click "Remove" in the dialog that pops up.
- If the Global Rules say to restart, restart the system and go back to Step 3.
- Select BARTENDER from the dropdown list as we do not want to remove any instances
- For Select Features, check all the boxes under BARTENDER. If there are no other instances on the system, you are safe to remove the shared features as well.
Note: you may see more than one checkbox beneath BARTENDER. All need to be checked.
- The wizard will ensure that there are no issues with what you've selected. If it says "Ready to Remove", click [Remove]
- Once the SQL instance you receive the confirmation screen, restart the system
SQL litters with its backup files and processes. If you do not clean up the litter and install a new BARTENDER instance, it may possibly pick up the old information and dirty your new install.
By default, the SQL installation folders will be located here:
- 64-bit: C:\Program Files\Microsoft SQL Server
- 32-bit: C:\Program Files (x86)\Microsoft SQL Server
Delete the folder labeled MSSQL##.BARTENDER. If the BarTender installer installed SQL, the folder will likely be labeled MSSQL12.BARTENDER as SQL 2014 is SQL v12.
You can now reinstall BarTender normally. If you are installing BarTender without SQL, please follow the instructions here.