I am having some issues with Management Studio and the registry.
At some point, someone - prior to my arrival - decided to change a SQL Server installation. They changed it from a named instance to a default instance. The named instance was RBLEGAL. It's now just a default instance.
The person who made the change failed to make the appropriate changes to the sysservers and syssubsystem tables.
What I noticed is that the registry was still hanging onto the old named instance information. Specifically the "Instances" key. It still listed RBLEGAL as the key and the data value as MSSQL.1, which is not correct in this case.
I modified the key to be MSSQLSERVER as the name and MSSQL.1 as the data value to reflect that this is now a default instance.
Now, when I try to view properties of the server in Management Studio, I get the following error:
RegOpenKeyEx() returned error 2, 'The system cannot find the file specified'. (.Net SqlClient Data Provider).
I'm sure this has something to do with the modification of the key, but how can I get Management Studio to "refresh" what key it's looking for?
Any help would be appreciated!!!
A. M. Robinson
View Complete Post