Where is SQL2K8 Registered Servers Data Kept?

Question

Post reply

Where is SQL2K8 Registered Servers Data Kept?

GAF

Mr or Mrs. 500

Points: 546
More actions
January 20, 2010 at 12:12 pm

#209260

Had to reinstall SQL2k8 after hard drive failure on local desktop.
When accessing Registered Servers nothing shows, not even local and I get a .net framework message 'Key not valid for use in specified state'
I want to delete the previous registered servers but they do not appear in the Registered Servers tab. Where did SQL 2k8 put the Registered Servers Info?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 1

You need to locate the registry key for the old installation and remove it before proceeding with the new install...

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

GAF Mr or Mrs. 500 Points: 546 More actions · Answer 2

I've crawled HKLM-Software-Microsoft-Microsoft SQL Server settings in the registry and never found it. I uninstalled MSSQL2k, 5k and 8k and completely deleted all directories and every reference to MSSQL in the registry. When I reinstalled, same darn problem. Any idea what key?

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 3

Did you have SSAS or SSRS installed too?

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

GAF Mr or Mrs. 500 Points: 546 More actions · Answer 4

First install was with everything, SSIS, SSAS, SSRS, etc... 2nd install tried for management tools only.

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 5

Then just rename or delete the VS folder from the below path...

'C:\Documents and Settings\%username%\Application Data\Microsoft\VisualStudio'

Hope this helps...

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

GAF Mr or Mrs. 500 Points: 546 More actions · Answer 6

I can still connect to my sql2k8 servers and run queries, etc. and they show up in object tab.

If I try to register from there I get message saying it's already registered but still can't see any servers in registered servers tab.

GAF Mr or Mrs. 500 Points: 546 More actions · Answer 7

Not exactly but you were close so you win the cigar and a big brewski!!! Buried under C:\Documents and Settings\user\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\ is a litle file named RegSrvr.xml

You got me there!! Thank you!!

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 8

yay..:cool:

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."