Post reply

Problem in accessing tables in linked server.

  • September 6, 2008 at 1:36 am

    #197818

    Dear All,

    Am working in sql server 2000. I adde a linked server which is SQL server 2005. It got connected succesfullly. But am able to see only 'MASTER' database. When I opened query analyzer executed a query to select records from one of the table in linked server am gettng the following error.

    OLE DB provider 'Linkedserver_ip' does not contain table '"dbo"."DBName"."customers"'. The table either does not exist or the current user does not have permissions on that table.

    Please help..very urgent.

    Regards,

    Santhu.

  • September 6, 2008 at 6:21 am

    #868131

    Hello,

    This is probably because of the security context that you are using to access the Linked Server. For example, are you passing through the Windows/SQL Login that is accessing the SQL 2000 Server, or using a single SQL Login, configured in the Linked Server properties?

    Regardless of which, the chosen Login needs to have access to the DB on the SQL 2005 Server, and then have permission to access the “customers” table.

    Hope this helps.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

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

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