I'm running SQL Server 2014 and have 50 separate instances running. This is the max limit of number of instances for this version and I obviously need to uninstall some instances and clean up.
However upon research there's a bug which won't allow you to uninstall instances through the Programs and Features installer or command line when you have 50 instances installed. The installer freezes when querying the list. I checked the bootstrap log files and the exported errors state that it can't perform the operation because there are too many instances which is the whole problem in the first place!
I need to uninstall the instance through the registry. I was able to remove the instance from HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall using msiexec but when I did that the SQL Browser service crashed, the other sql instances lost connection and the services for the old instance would reappear. I had to restore the registry from the backup I made. Is there a way to remove an instance from the registry properly and re-situate the browser service? Maybe some registry items I'm missing?
No comments:
Post a Comment