Thanks for the response but I do not want to use logged on credentials to run the report. I want to dynamically send the login credentials for each report as parameters. It works just fine for a local server but when I deploy it to production server, only way to make this report run is provide login credentials in Property tab under DataSource section.
Basically I need this architecture to use same set of reports for 20 different clients each of them using different server name, database name, user name and password.
If I specify Credentials are not required it gives error :
The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCreden
But when I go to "Credentials stored securely in the report server" and specify credentials, it works. I'm trying to avoid specifying user name and password in Property section - in stead I need to pass them dynamically, just the same way I can pass server name and database name.
Any help will be greatly appreciated.
Thanks
by: OriNetworksPosted on 2009-04-23 at 19:23:55ID: 24221285
In your connection string you are using userid and password. You have to change your connection string to look more like
Initial Catalog=MyDb;Data Source=MyServer;Integrated
Integrated Security=SSPI; tells the server to use the current logged on credentials.