Report Specific Data Source in sql Server reporting Services

Hi everyone.

I have problem in sql server reporting services.

I have created a sql server report in viisual studio 2003 using the report specific data source, not shared data source. I also set the credentials when i define the data source for the report.

When i test it in report manager, it runs nice and displays the required results. Now when i called this report in web application using the following URL:

<script>varpreview=window.open('http://phx-ps01/ReportServer?%2fISTEPS%2ftest&rs%3aClearSession=true&rc:Parameters=False');preview.focus();</script>

It gives a report service error which is as follows:

"One or more datasource credentials required to run the report have not been specified. (rsCredentialsNotSpecified) "

This error shows that the credentials for the connection string is not set, but i set it when i define the data source for the report.

If any one can help, then please help as i am need of it urgently.

Thanks in advance.

Rizwan

Hi,

Try to create a shared connection and use that in your reports. while creating a connection, save credentials information too, otherwise it will ask on next new requests.