February 3, 2005 at 6:48 am
I wrote a simple report in VS.Net to test setting up Reporting Services. When I attempt to run the report I ran, I get the following error:
"The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing."
I have installed reporting services on my computer and the ASPNET user has access to the reporting services database on the server.
Does anyone know what is wrong and how to fix it?
Thanks,
Michael
February 4, 2005 at 8:10 pm
I would start by deploying the sample reports that install with Reporting Services. Try to run them at http://servername/Reports. If they run, then you know the problem is specific to your report.
Also, it is unlikely that the ASPNET user is relevant, since Reporting Services generally using Windows authentication and impersonation, so it is probably connecting to the database using a windows identity (unless you specified a SQL Server login in the data source for the report).
Scott
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply