SQL Server Performance

reanme linked server

Discussion in 'ALL SQL SERVER QUESTIONS' started by lara999, Oct 25, 2012.

  1. lara999 New Member

    Can I rename my linked server., i am a newbie i searched online but confusing answers...so experts any opinions...
  2. Shehap MVP, MCTS, MCITP SQL Server

    Renaming the linked server should be done through 2 steps:

    Configure alias at the source DB server :

    · RDP to the Source DB server ( Server hosting the DB instance where you are planning to create this new linked server ) .

    · Open Run>>>Alias>>>Add> select TCP/IP protocol from left panel >>put the connection string within Server name command box>> and assign the appropriate alias( the new name of linked serve)>>>>mark out dynamic port to be static like 1433 Accordingly to your configuration of the destination

    Configure the linked server to the destination DB Server

    · Go to the configurations of linked server, drop the current exists one , create another one with the new name used for the above alias …

    · Right click Linked server and Test connection , it should come out to you with a success message

    If it still persists, kindly let me know

Share This Page