Thursday, March 22, 2012

Can't access SQL Server Reporting Services URL anymore

Hi all,
We've had a Reporting Services installation for nearly 6 months now with no
problems. Reporting Services is installed on a Windows 2003 machine which is
connecting to SQL Server 2000 databases.
This morning, it was reporting that the URL to access the report server
(http://server/reports) is returning the following error message:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing.
(rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
Not sure where to go from here. Nothing has changed as far as we can tell.
Thanks,
JasonThere's also an error in the event log of the Reporting Services machine that
states:
Report Server cannot connect to the report server database.
How do I re-establish this connection? The database still resides on the
same server, same name as before. I am not sure how this happened.
"Jason" wrote:
> Hi all,
> We've had a Reporting Services installation for nearly 6 months now with no
> problems. Reporting Services is installed on a Windows 2003 machine which is
> connecting to SQL Server 2000 databases.
> This morning, it was reporting that the URL to access the report server
> (http://server/reports) is returning the following error message:
>
> The report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing.
> (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
>
> Not sure where to go from here. Nothing has changed as far as we can tell.
> Thanks,
> Jason
>

No comments:

Post a Comment