Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 192.168.xxx.xxx...

Any help much appreciated.

share|improve this question

migrated from stackoverflow.com Oct 6 '12 at 6:34

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

1 Answer 1

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.