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 |
|
scholin
Yak Posting Veteran
56 Posts |
 Posted - 2010-02-05 : 13:31:03
|
| I am fairly new to SQL Server Reporting. I am using SQL server 2008, running on a server using server 2008 standard and Business Studio to create the reports. I have built my report which can be accessed via a button on my secure (ssl) website and it all works great.However, I have yet to find a way to eliminate the need for the credentials to be entered once each day (plus the first time each takes like 60 seconds).I have tried various methods including using dsu, dsp parameter in the URL but no luck. I get the sense that because I am using windows Authentication, even thought it says "integrated security", I have to do something else.If I try to assign user name and password, it is apparently looking for something else than windows credentials.Because the people who come to my web site are already using secured logins, I don't want them to have to do anything other than hit the button to display their reports.Can someone point me to "clear" instructions on how best to set this part up? Thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-05 : 13:35:09
|
| i think what you need is to create a shared data source which all your users have access to and make reports use that |
 |
|
|
|
|
|
How to have a report open without credentials