Post reply

Linked Server: "error 17: sql server does not exist or access denied"

  • July 20, 2006 at 1:08 pm

    #171606

    I have created a linked server to server A from server B with EM.  However, when I try to access it's tables or views I get "error 17: sql server does not exist or access denied".

    Server B is a named instance on a separate box than server A and the weird part is that I can access server A's tables and views through a linked server on server C.

    I have checked the linked server properties between server B and C and they appear to be the same.

     

  • July 20, 2006 at 1:25 pm

    #650507

    Have you also checked security delegation?

    Does sql server runs under the local system account or under a domain user account?

  • July 20, 2006 at 2:09 pm

    #650520

    Thanks for the quick response,

    I have not checked the security delegation, please advise

    The sql server runs under a domain user account

  • July 21, 2006 at 5:59 am

    #650638

    The tab security of your linked server to A is completely the same than on server C?

    Does the linked server works with always use this security context?

Viewing 4 posts - 1 through 4 (of 4 total)

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