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.

• Robert Davis

  One Orange Chip

  Points: 28027

  More actions

  November 21, 2006 at 12:15 pm

  #673288

  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: 323522

  More actions

  November 22, 2006 at 7:38 am

  #673456

  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: 323522

  More actions

  November 22, 2006 at 7:59 am

  #673464

  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!