I have setup a SQL Reporting Services 2008 R2 server which contains data sources that connect to databases on a remote SQL 2008 server. In the data source the connection string is defined and "Connect using:" is set to "Credentials Stored Securely
in the Report Server", I have entered the credentials required to connect to the remote SQL 2008 server where the database resides and there is no problem when I choose "Test Connection".
When I access the Report Builder through the SSRS website and create a new report I can add the data source to the report without an issue. When I try to create a new dataset and specify to "Use a dataset embedded in my report" I can choose the data
source but when I try to then open the Query Designer I am prompted to enter the credentials for the data source. The username I saved in the data source on the Reporting Server seems to default in however the password does not.
I see on MSDN (http://msdn.microsoft.com/en-us/library/ms159736.aspx) the following:
"You can specify a single set of stored credentials that a report server uses to access external data for a report. Stored credentials are used if the report runs unattended. The report server retrieves and uses the credent
View Complete Post