Post reply

Linked server error

  • July 23, 2010 at 7:19 am

    #227123

    When i access all tables through linked server. I get this error for only one table

    Msg 7313, Level 16, State 1, Line 2

    An invalid schema or catalog was specified for the provider "SQLNCLI10" for linked server "LinkedServername.DBName.dbo.tablename"

    iam able to access all tables except one table. The schema for the table is same as other table. Linked server user has full permission. Iam working on sql server 2008. Please help

    Thanks,

    Amit kulkarni

  • July 23, 2010 at 7:34 am

    #1197502

    Check whether local user (used in linked server) has access to the table...???

  • July 26, 2010 at 12:59 am

    #1198031

    Hi Summit,

    The local user is member of sysadmin role. So i suppose its not the issue with permission.

    Thanks,

    Amit Kulkarni

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

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