Post reply

linked server set up

  • January 12, 2004 at 7:49 pm

    #107354

    I have troubles setting up a linked server to SQL. I did set up the linked server and the logins to it and if I try to access it from the SQL server itself - either EM or QA - everything is OK. I could run queries, open tables, etc. But if I try to access the linked server from another QA or EM on the network, then the access is deny - error 7399, but I know I did setup the logins correctly.

    Any ideas what could be wrong?

    Thanks a lot.

    MJ

  • January 14, 2004 at 12:31 am

    #489899

    Have you tried accessing the data in the linked server using a view and then trying to access the view from the remote servers?

  • January 14, 2004 at 9:30 am

    #490001

    This is not the point at all. I could access everything from within the SQL Server itselt (I mean if I open the EM or QA on the server). The problem is if I try to open the tables/views/ run queries form EM or QA on the other machine - then the authentication for the NT users on the linked server does not let me do it. What I'm missing is the mapping of the local SQL logins to linked server security - it does not matter what login mapping I use - selfauth, or to a particular user, or to the admin acct. The problem is that I did everything described in BOL, and I have done it several time before the same way and it has been always working for me.

    What I'm missing this time?

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

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