Post reply

Linked Server

  • August 12, 2005 at 1:05 pm

    #88616

    How to name the Linked server.

    I have IP address which I link to the server but they change the IP address very frequently, can I name the Linked server??

    How to do that??

     

    Reddy

     

     

  • August 12, 2005 at 1:07 pm

    #581948

    Check out sp_addlinkedserver in books online.

  • August 12, 2005 at 1:19 pm

    #581962

    I know how to add linked server but how to name the linked server...

    I have linked server with IP address 1.2.3.4 every week they change the IP address I want to name the linked server so that I don't have to update all login id's to that linked server

     

     

  • August 12, 2005 at 1:23 pm

    #581966

    Hmm, what do you get if yo run Select @@ServerName on that server?

  • August 12, 2005 at 1:37 pm

    #581972

    I get BMDPROD

    but when I ping it says unknown host?

     

  • August 12, 2005 at 1:39 pm

    #581975

    Wow that's out of my knowledge... I'll let the "network" dbas handle this one.

  • August 12, 2005 at 1:51 pm

    #581979

    I believe the reason you are using IP instead of server name is because server name doen't get resolved by the DNS.

    I if the name of the server never changes than go to cmd and ping the server using it's IP address

    ex: ping -a 1.2.3.4

    you should get back server name corresponding to the IP

    first line should look like this : pinging BMDPROD.?????.??? [1.2.3.4] bla bla

    ping the server name BMDPROD.?????.??? and see if it gets resolved if it's the case then use that name "full name"

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply