Post reply

Linked Server problem

  • July 8, 2010 at 7:11 am

    #141024

    I have linked servers that I just created. When I hit the test button they both test just fine..

    but I get this error message:

    The OLE DB provider "SQLNCLI" for linked server "ssds_server" does not contain the table ""sqlcompliance"."dbo"."agentevents"". The table either does not exist or the current user does not have permissions on that table.

    Are there special permissions I need for this?

    I don't see my DB's or tables I need under catalog either...

  • July 8, 2010 at 7:28 am

    #1190224

    I chnaged some things now I'm getting a

    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

  • July 8, 2010 at 7:31 am

    #1190227

    I have also encountered both the errors you mention, in the end I explicitly mapped the database I needed using the @catalog parameter.

    EXEC master.dbo.sp_addlinkedserver @server = N'NameOfLinkedServer', @srvproduct=N'AnyNamedLink', @provider=N'SQLNCLI', @datasrc=N'YourDataSource', @catalog=N'YourDatabase'

    It may also be worth reading this post regarding permissions...:

    http://www.sqlservercentral.com/Forums/Topic904688-146-1.aspx

    gsc_dba

  • July 8, 2010 at 8:08 am

    #1190257

    Thanks man

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

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