Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hoping someone can help - is there a way in SQL server management studio 2008 R2 that I can alias a linked SQL server?

I have a server, added by IP address, to which I do not have the login credentials - however as the connection is already setup I can login ok.

Issue is that, this is a dev environment, prior to a live deployment and the IP I have as a linked server needs to be 'accessible' by my stored procs under a different name, eg 'myserver' not

Any help much appreciated.

share|improve this question

migrated from Oct 6 '12 at 6:34

This question came from our site for professional and enthusiast programmers.

This method seems to work:

The details in case that link goes bad:

There are no problems to add SQL linked server to the specific host running it. But what if you need to give it an alias, rather than use hostname as linked server name? Here is how to do it:

Step 1:

  • In SQL Server Management Studio open Linked Servers and then 'New Linked Server'.
  • Inside of appeared wizard – Select the General tab.
  • Specify alias name in "Linked server" field.
  • Select SQL Native Client as provider.
  • Add sql_server in "Product Name" field (that's the magic).
  • In "Data Source" – specify name of the host to be used as linked server.

Step 2:

  • In Security tab – specify proper security options (e.g. security context)

Step 3:

  • In Server Options tab – put "Data Access", RPC, "Rpc Out" and "Use Remote Collaboration" to be true.
share|improve this answer
What is the notation to select from a table on this server then? – tbone May 25 at 20:10

Follow the steps to create new alias->all programs->microsoft sql server 2008 R2->Configuration tools-> select sql server configuration manager->select alias->new alias->then enter server name

share|improve this answer
Thanks. That seems to allow aliasing of a server to connect to when doing so directly from SQL management studio (which will still be useful - thanks), but my main problem is updating a 'linked server' from one of my Dev VMs.. – absentmindeduk Oct 5 '12 at 9:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.