10 March 2008

How to add to the list of available SQL Servers

Have you ever wanted to add to the list of SQL Servers found in Red Gate’s SQL Compare, SQL Data Compare, SQL Doc or even SQL Data Generator?

If so, here goes.

All you need to do is add the name of the SQL Server instance to the registry. The application looks for servers named 0,1,2,3…. under ‘HKCUSoftwareRed GateSharedServers’. You will also need to add an offset which has a limit of 10. If you are adding more than one server, increment the offset by 1 and add a new key for each subsequent server with the next consecutive number upto a maximum of 9.

In the following example I will add a new server with a customized connection string to specify a port number over TCP/IP.

Start up your regedit.exe, and navigate to ‘HKCUSoftwareRed GateSharedServers’. (You may need to create the last part.)

Add “0” as a string with the server that you wish to add eg:

DCHowtoaddImage1.png

Add or modify “offset” (DWORD) to 1

DCHowtoaddImage2.png

So now my registry looks like

HowtoaddImage3.png

Now Refresh your list of SQL Servers and this new item has been added.

There you go, it was that simple.

Keep up to date with Simple-Talk

For more articles like this delivered fortnightly, sign up to the Simple-Talk newsletter

This post has been viewed 1506 times – thanks for reading.

  • Rate
    [Total: 0    Average: 0/5]
  • Share

David Connell is a Software Developer who led the team that created the SQL Data Generator at Red-Gate. Before then, he led the 'SQL Toolbelt' installer and the SQL Doc team, and before that worked in the SQL Bundle 5.0 team. He was previously a Senior Software engineer at Pi Research. In his spare time David Connell develops other software packages with a Dutch Company, Thermimport Quality Control.

View all articles by David Connell