SSRS against remote database - double hop authentication?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gart - 25 May 2008 11:55 GMT

I'm running into some SSRS issues, I'm fairly new to SSRS. I've got
the following setup:
Server_A: SQL 2005 Standard with SSRS
Server_B: SQL 2005 Standard
WINXP_A: end user workstation

I want to create a report on Server_A using the database on Server_B.
The report is able to run locally on Server_A (connects to database on
Server_B and grabs the data using a URL referencing http://localhost/Reports/Pages/...).
Using WINXP_A, when I access the same report using the URL
http://Server_A/Reports/Pages... I am presented with an authentication
window. I put in the same username that I logged on to Server_A that
ran the report successfully. However, I get back the message stating
that the connection to the data base could not be opened.

Does this describe the double hop authentication issue and is there a
clean way around it?

Reply to this Message

Wayne - 28 May 2008 19:35 GMT

> Does this describe the double hop authentication issue

Yes

> and is there a clean way around it?

It involves setting up Kerbosis properly. Always fun.

Another way (less secure) is to set up a generic sql user in the database,
and have the datasources for the reports to use this user. If you are using a
shared datasource, this will be relatively straightforward to do.

> I'm running into some SSRS issues, I'm fairly new to SSRS. I've got
> the following setup:
[quoted text clipped - 13 lines]
> Does this describe the double hop authentication issue and is there a
> clean way around it?

Reply to this Message