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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-10-16 : 02:21:42
|
| Hi,I Created Report using shared data source but when I try to run this report using dynamic connection string parameter I am getting errorI supplied parameter to connection string is"data source=" & Parameters!Server.Value & ";initial catalog=" & Parameters!Database.Value &";user id="Parameters!LoginID.Value & ";password="Parameters!Password.ValueI also created these parameters like Server, Database, LoginID, Password in report paramentersbut when I try to run this I am getting either of these errorserror no 1.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. (rsInvalidDataSourceCredentialSetting) error no 2.An error has occurred during report processing.Cannot create a connection to data source 'SRVDataSource'.For more information about this error navigate to the report server on the local server machine, or enable remote errors Please help me outT.I.A |
|
|
abacusdotcom
Posting Yak Master
133 Posts |
Posted - 2008-05-16 : 08:59:10
|
| this should help you out.Go to BIDS, open report project. Double click on data source(.ds) file. Click on Credential Tab, check Use Windows Authentication (Integrtated Security)I sign for fame not for shame but all the same, I sign my name. |
 |
|
|
|
|
|
error for the user data source credentials.