June 20, 2013 at 8:26 am
Hi, I'd like some advise on deploying a report to a server where the datasource is on a separate server.
I'm currently creating the report on my local machine, which is using SQL 2012 Data Tools. The database is hosted on a SQL 2005 Server. I'm deploying to a SQL 2012 Server. All on same domain, etc.
I'm currently getting an error when accessing the report via a browser:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
When I access the log I see:
library!ReportServer_0-8!5bec!06/20/2013-15:17:07:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I've previously successfully made reports where the database was on the same server as the reporting server, but never tried it this way. Any tips?
June 20, 2013 at 4:06 pm
Is the report set up to connect to the database with the credentials of the user that is running the report? Looks like it's a 'double-hop' issue where the user can't be passed from the report server to the database. ie, one hop is from the client machine to the report server and the second hop is from the report server to the database server.
To resolve this either set up an SPN on the account that the report server service runs under and enable kerberos or use a different account in the report datasource connection. I prefer to use a dedicated report account so that users don't need to be added to the database.
June 24, 2013 at 5:14 am
Thanks, I've added a dedicated reporting user and am accessing the database with that now.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply