Thoughts on technology and innovation
Dave Domagala, Manager of Customer Success
I recently came across an issue when working w/ linked servers in SQL and had to do a bit of digging to get it to work correctly so I figured I'd share it with the world. The challenge was to setup a linked server for SQL that used an Alias instead of just the server name. Although it may seem straight forward, the bit of the challenge was that the linked server was not the default instance of SQL, but a named instance.
Through various forums and posts, I was able to find the following process to correctly get this configured. The main trick to the configuration is that instead of using SQL 2005's "SQL Server Configuration Manager" for setting up the alias, use the legacy (earlier SQL 2000) utility of cliconfg.exe
The steps for this are as follows:
4. Click OK twice to apply and exit out of cliconfg.exe
Now that our Alias is setup, we can setup our Linked Server in SQL Management Studio. To do that, open SQL Management studio and follow the steps below.
Branch out the Server Objects and right click on Linked servers to select New Linked Server
Using the New Linked Server wizard, fill out the information for your Linked Server.
Add the logins used to connect to your Linked server, or specify an alternate for non defined logins and click Ok
Under Server Options:
Click OK and test out the new connection.