Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pinkfloydhomer
Starting Member
3 Posts |
 Posted - 2009-10-26 : 05:16:25
|
| I have a report that uses a shared data source with no stored credentials. It is called with user supplied credentials from an application by using the query strings dsu and dsp. It works fine.But when this report itself then opens a drillthrough report (which uses the same shared data source), the drillthrough report asks the user for credentials. It seems that credentials are not passed to the drillthrough report.How can I solve this problem? Ideally, I want the first report to use the credentials supplied to it, to open the drillthrough report using the same credentials. |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-26 : 09:04:10
|
| If you change your datasource to Use Windows Authentication (Integrated Security)the user should not be promped.JohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
pinkfloydhomer
Starting Member
3 Posts |
Posted - 2009-10-27 : 07:22:40
|
| Doesn't work for me. I can't believe that the built in functionality of drill through and the built in functionality of getting credentials from the user/app instead of storing them with the datasource, doesn't work? |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-27 : 07:47:16
|
| Do you use active directory for authentication?JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
pinkfloydhomer
Starting Member
3 Posts |
Posted - 2009-10-27 : 10:55:47
|
| No, this is an old system that uses it's own authentication scheme within the application. The credentials are passed with the dsu and dsp query strings when calling the report. This works fine, and is also a perfectly good and documented way of calling a report. The problem is that when a report then spawns another report via drill through, it doesn't pass the credentials on the report it spawns.There is a good reason why report server allows passing credentials within the url and why it is possible to use a shared data source without stored credentials. So this should be possible. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-27 : 11:31:39
|
| I agree but then this IS Microsoft we are dealing with... I have never gotten that to work unless it is using AD.JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
|
|
|
DrillThrough and credentials