re: Moving SQL Server aliases to another computer

Ivo Pereira — Mon, 08 Nov 2010 14:58:33 GMT

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

re: Moving SQL Server aliases to another computer

roman — Mon, 08 Nov 2010 19:23:28 GMT

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.