title: SSRS Report, SQL Linkedservers, Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
body: <p>I've created a report that targets 2 databases "A" and "B". In my report, I'm using a static datasource connection to database "A" and a dataset that also uses this datasource. This datasource uses windows authentication. On database "A" I have linked server "B" to it using this line of code:
  exec sp_addlinkedserver @server='', @srvproduct='', @provider='SQLNCLI', @datasrc=''. On "A" I have created a working sproc that executes queries successfully for both "A" and "B" in SSMS. </p>
  
  <p>In my report, I have a @ServerName parameter and it passes the proper value to the sproc. I know its working because server "A" works within my report using the "Preview" tab and when deployed.  But server "B" always gets the same error message per the title. I think it has something to do with my static connection string, but since the sproc works shouldn't it only need a connection to server "A" only?</p>
  
  <p>I tried to be as thorough as possible I've been fighting this for 2 days and would love to get this simple problem nipped in the bud, thank you very much.</p>