December 8, 2008 at 2:13 pm
I get the following error when attempting to launch a report in Reporting Services that connects to an Analysis Services instance:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'XXXXXXXXX'. (rsErrorOpeningConnection)
The connection either timed out or was lost.
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host
The error occurs if the datasource is configured to allow connections using "Windows integrated security".
However, if the data source is configured to allow connections to use credentials supplied by the user running the report (and use them as Windows credentials when connecting to the data source), the error does not occur.
The problem with this approach is that the user has to enter his/her Windows-auth. credentials every time they want to launch the report, which is a pain.
It would be preferable if the Windows auth. was done behind the scenes instead (using the "Windows integrated security" option).
Any ideas anyone?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
December 8, 2008 at 2:23 pm
Perhaps check your accounts under Reporting Services Configuration Manager under "Database Setup" and "Execution Account". Have you changed a password recently?
December 8, 2008 at 2:33 pm
Nick1234 (12/8/2008)
Perhaps check your accounts under Reporting Services Configuration Manager under "Database Setup" and "Execution Account". Have you changed a password recently?
This seems to be an issue with Kerberos delegation. There is another posting on the same issue:
http://www.sqlservercentral.com/Forums/Topic536160-147-1.aspx
The problem is I cannot access one of the links mentioned:
http://www.mosha.com/msolap/articles/kerberos_delegation.htm
The following seems to be the best link I have found so far. I will have a look and see if that resolves my issue:
How to configure SQL Server 2005 Analysis Services to use Kerberos authentication:
http://support.microsoft.com/kb/917409
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy