Post reply

Linked servers -different instances, same machine

  • July 2, 2004 at 6:04 am

    #84842

    I have two instances running on the same machine which, for example, are called MYSERVER and MYSERVER\MYINSTANCE.  I want to set up MYSERVER as a linked server from MYSERVER\MYINSTANCE but get the error 'Cannot find server MYSERVER'.  The only way I can get it to work is to create the linked server using the IP address, for example 123.123.123.1 but then have the problem in having to referring to tables on it as [123.123.123.1].Database.Owner.Table which doesnt work...

    any ideas?

  • July 5, 2004 at 5:04 am

    #513271

    Use the Client Network Utility and set up an alias for MYSERVER\MYINSTANCE.  It's the \ that is the killer !!.

  • July 5, 2004 at 5:14 am

    #513273

    Thanks ... but it is MYSERVER that I want to Link to (not MYSERVER\MYINSTANCE).  And should I create the Alias on the server machine itself or on every user's?

Viewing 3 posts - 1 through 2 (of 2 total)

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