If you are anything like me and you regularly forget the SA password for a SQL Server instance and then delete your own Windows user from the server then you will need to install a new instance.
Then you have two... or four instances, in my case. Don't ask.
Here is how you uninstall a specific instance since you are locked out and can't use it anymore. There are other good reasons that may bring this about but mine is far too common, so do this...
- Go to Control Panels > Programs > Uninstall a program. This is also known as Add or Remove Programs;
- Find the type of server you are uninstalling. In my case it is Microsoft SQL Server 2008 R2 (64-bit). Right-click and choose Uninstall/Change;
- At this point, you may be asked to locate your installer program. That is the program you used to install it in the first place. Locate that. You will be presented with several options. Choose Remove;
- Select the Instance you want to remove and follow the instructions to uninstall it.
You may want to write down that SA password for the new instance somewhere.