THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Roman Rehak

Moving SQL Server aliases to another computer

I utilize SQL Server aliases a lot, especially since for some reason I don't get name resolution on our network over VPN. So I typicaly create an alias and map the name to the IP address of each SQL Server I use a lot on the network. I am in the process of setting up a new laptop and I was going to start recreating them. Then I remembered that since aliases are stored as registry values, I could use the registry import/export feature. I wasn't sure if it would work between Windows Server 2003 and Windows 7 but luckily, it did.

 If you want to do this, go to the "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo" node, you should see all your aliases there. Then, export the whole node to an REG file, transfer the file to the other computer, and import it through the menu or by running the REG file.

 

 

Published Sunday, November 07, 2010 4:06 PM by roman
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Ivo Pereira said:

Hello, Roman.

After seeing your post I searched in my registry and I can´t find the key you mention. You don´t mean linked server aliases, or database table alias, right? I tought those were stored in the database itself..

I found my ODBC connection settings somewhere else in the registry, so I assume that you weren't refering to those algo. Maybe you can shed some light on what are server aliases :)

I use Window 2008 R2, maybe the key is located somewhere else in my system.

Cheers,

Ivo Pereira

November 8, 2010 9:58 AM
 

roman said:

No, not linked servers or synonyms. These are the client connection aliases, they allow you to alias a server name to another name, or link it to an IP address. Run cliconfg from DOS to open the SQL Server Client Network Utility, you can view and edit aliases there.

November 8, 2010 2:23 PM
 

http://Www.wattpad.com/ said:

Roman Rehak : Moving SQL Server aliases to another computer

November 6, 2014 9:19 AM

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement