June 23, 2008 at 9:17 am
Hey all,
I'm using reporting services to query remote servers through a stored procedure utilizing OPENDATASOURCE with integrated security both in SSRS and in the stored procedure (Integrated Security=SSPI).
From SSRS I'm getting:
An error has occurred during report processing.
Query execution failed for data set 'VSSDetail'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
On the remote SQL server I'm getting: Login failed for user '(null)'.
All servers are running under the same service account, which have adequate permissions between servers. The procedures run just fine using my NT account on the source server which holds the procedures.
Not sure what I'm missing here ... The double hop issue should not be the problem because I'm using KEREBROS right? I've tried changing the data source in SSRS to impersonation with no luck ... seening as I am the only one who has the proper permissions to all the servers, i wanted to impersonate authentication with my service account.
Any thoughts are most welcome.
Thanks
June 23, 2008 at 9:22 am
Actually, I think I got it ... I used Use as Windows credentials when connecting to the data source, and took off Impersonate ... appears to be working just fine.
June 23, 2008 at 9:27 am
I would guess you do not have KERBEROS configured correctly. Typically, when you cannot authenticate with KERBEROS, security will try NTLM and give you the error you are seeing. Check the security log on the SQL Server that is running the OpenQuery.
This SQL Server is the one that would need an SPN for the SQL Service account / MSSQL Service (or your proxy if you are using one) to allow it to ask for a KERBEROS ticket.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply