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.
