Post reply

Linked server in Sql Server 2008

  • November 30, 2016 at 12:53 pm

    #401137

    Hello Guys I have one issue about linked server. Let me try to explain what is going on. I have 3 server, 1 ,2 and 3 I have a database in the server 1 and other database in the server 2 I would like to get data from this both servers. I have already created the linked server in database 1 and database 2 and its working properly, in the server 3 I have reporting service my problem happening when I open the Database 2 in the server 3 and try to test the linked server the same way I do when I am conected localy in the server 2 when I do this I get the Error

    "Login Failed for user 'NT AUTHORITY\ANONYMOUS LOGON' someone has any idea how could I get this working in this server 3 "Reporting service"

    Best Regards

    Peterson Soares

  • November 30, 2016 at 4:24 pm

    #1915301

    Linked server double-hops (from 3 to 2 to 1) are more complicated to set up than single hops. This [/url]link has more detail. Also, make sure you're setting up permissions on servers 1 and 2 for the user in the SSRS data source, not just yourself.

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

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