After reading all kinds of posts regarding this, I am totally confused as to which way to do this. So, I'm asking the experts for help.
I have a web front-end that is controlled by Windows Authentication(they have to sign in to the domain before they can access the page). Then, the page will display the reports that are available to that user. The user can click on a report in the gridview and they are redirected to another webpage, with the reportviewer control pointing to a remote report. (this report is on a reporting services server that uses windows authentication as well)
My problem is, how can I pass along the credentials in an easy way? I have access to the username and domain, but not the password.(at least, I haven't been able to find where the password can be retrieved). I know I have to assign the current user to the reportservercredentials, but how do I do that if I don't know or have their password? Am I missing something from all the examples I've seen? It seems that all the examples require that I have the USERNAME, PASSWORD, and DOMAIN in order to set the RS credentials.
Would I be better off processing the report in local mode instead of trying toauthenticate to the server?
If anyone can point me to some VB.NET examples I would greatly appreciate it. I had this entire application working with Forms Authentication, but the "powers that be" wanted me to user Windows Authentication instead, and now I'm at my wits end trying to get this implemented before the 2nd week of May.
Thanx again,
Mike