locked
How to impersonate user for data on another server? RRS feed

  • Question

  • Hello all,

    I have a quick question. The sql reporting server is on server A, and the actual data for the report is on a sql server 2005 called server B. When I am actually developing my report and click preview, everything works perfectly using windows authentication. However, whenever I publish and try to view the report, i get this error:

    • An error has occurred during report processing.
      • Cannot create a connection to data source 'serverB'.
        • Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
    How do I change the login for this datasource while still using windows authentication and not mixed mode?

    Thanks
    Tuesday, December 26, 2006 9:48 PM

Answers

  • Go to the data source properties in the Reporting Services Manager and you can put in a Windows or SQL Server user name and password for the data source.
    Tuesday, December 26, 2006 10:23 PM