SQL Server Performance

Linked Server 'access denied'

Discussion in 'General DBA Questions' started by Eman, Nov 13, 2003.

  1. Eman New Member

    Hello all, this is kind of odd, I have a sql 2000 named instance. I add it as a linked server to another 2000 server, when attempt to looks at the tables from EM I get the following error 'SQL Server does not exist or access denied' I've tried several ways to connect with the same result. I've connected using 'sa' account, though scripts and the spaddlinkedserver stored proc and then ran a query. I'm out of ideas, any one ran into this before?

    Thanks...
  2. Negative New Member

    Have you tried creating an alias for the server with the client network utility and specifying the network library? We use only TCP/IP for our servers, and that is usually the problem I run into.
  3. satya Moderator

    When you'd used SP_ADDLINKEDSERVER then it worked or not?
    If any errors what are they?

    And also how about service packs on both the servers?


    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  4. Eman New Member

    Got it, The SQL Server I was attempting to connect from was using an older ver of MDAC, updated it and now all is good.

    Thanks...
    Eman...

Share This Page