How to programmatically register a remote SQL Server?

Question

How to programmatically register a remote SQL Server?

SQL ORACLE

One Orange Chip

Points: 27807
More actions
November 19, 2006 at 9:30 pm

#67961

Many thanks for any input in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

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

Robert Davis One Orange Chip Points: 28027 More actions · Answer 1

This information is stored in the registry so you have to manipulate teh registry to do this. That's not something I would recommend to anyone unless they really know what they are doing.

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

Lowell SSC Guru Points: 323504 More actions · Answer 2

i know you can export the registry key and port it to other machines;

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group], but to add the items via a program would basically just be adding to that registry key; i'm not sure but maybe you can put it under default user registry key so that it appears for everyone. HKEY_USERS\.DEFAULT\Software\Microsoft

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Lowell SSC Guru Points: 323504 More actions · Answer 3

just wanted to confirm you must write to the registry at [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group],

adding it to the .Default does not work, so forget that idea.

much easier to simply copy that registry as a model, fiddle with it by using one of the keys as a specific model to add other servers, and then register the file, or write directly to the registry.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!