Hello All,
I have my Reportservices installed at a windows 2000 box (RSBox) and a
reportserver Database at a windows 2000 box (DBbox).
I am using Windows authentication.
I have been successully Deploying and viewing MS enterprise Reports .. but
suddenly i got a issue...
When ever I try to deploy or view the deployed reports I get an 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. "
I have checked my Report server database which is running and Reporting
services are also running also I am able to browse to reports level but when
I try to view it I get this error.
Any Idea how I can track this issue. There are other people too who are
owner of these production boxes. I need to trace where the issue is...
any Idea wil be highly appreciated..
Cheers,
siajCheck documentation on RSConfig. Set connection related information to what
you think it should be. If it still wouldn't work after that try using SQL
Query analyzer to connect to that database using same connection
information, see if that works.
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"siaj" <siaj@.discussions.microsoft.com> wrote in message
news:7E87933B-AF63-4B9D-A187-2D3BA9FBA507@.microsoft.com...
> Hello All,
> I have my Reportservices installed at a windows 2000 box (RSBox) and a
> reportserver Database at a windows 2000 box (DBbox).
> I am using Windows authentication.
> I have been successully Deploying and viewing MS enterprise Reports .. but
> suddenly i got a issue...
> When ever I try to deploy or view the deployed reports I get an 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. "
> I have checked my Report server database which is running and Reporting
> services are also running also I am able to browse to reports level but
when
> I try to view it I get this error.
>
> Any Idea how I can track this issue. There are other people too who are
> owner of these production boxes. I need to trace where the issue is...
> any Idea wil be highly appreciated..
> Cheers,
> siaj
>|||Thanks Dmitry...
Do u have any idea from where can I find the username used for the Report
server in clear text as the RSreportServer.config stores it in encrypted
form.
I want to know this as I suspect if this account has got locked due to some
reasons.
cheers
siaj
"Dmitry Vasilevsky [MSFT]" wrote:
> Check documentation on RSConfig. Set connection related information to what
> you think it should be. If it still wouldn't work after that try using SQL
> Query analyzer to connect to that database using same connection
> information, see if that works.
> --
> Dmitry Vasilevsky, SQL Server Reporting Services Developer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> ---
> "siaj" <siaj@.discussions.microsoft.com> wrote in message
> news:7E87933B-AF63-4B9D-A187-2D3BA9FBA507@.microsoft.com...
> > Hello All,
> >
> > I have my Reportservices installed at a windows 2000 box (RSBox) and a
> > reportserver Database at a windows 2000 box (DBbox).
> > I am using Windows authentication.
> >
> > I have been successully Deploying and viewing MS enterprise Reports .. but
> > suddenly i got a issue...
> >
> > When ever I try to deploy or view the deployed reports I get an 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. "
> > I have checked my Report server database which is running and Reporting
> > services are also running also I am able to browse to reports level but
> when
> > I try to view it I get this error.
> >
> >
> > Any Idea how I can track this issue. There are other people too who are
> > owner of these production boxes. I need to trace where the issue is...
> >
> > any Idea wil be highly appreciated..
> >
> > Cheers,
> > siaj
> >
>|||Hello ...
I could solve my Issue .. The userID and Password was locked. I got it
unlocked and restarted the IIS .. bingo it worked
cheers,
siaj
"siaj" wrote:
> Hello All,
> I have my Reportservices installed at a windows 2000 box (RSBox) and a
> reportserver Database at a windows 2000 box (DBbox).
> I am using Windows authentication.
> I have been successully Deploying and viewing MS enterprise Reports .. but
> suddenly i got a issue...
> When ever I try to deploy or view the deployed reports I get an 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. "
> I have checked my Report server database which is running and Reporting
> services are also running also I am able to browse to reports level but when
> I try to view it I get this error.
>
> Any Idea how I can track this issue. There are other people too who are
> owner of these production boxes. I need to trace where the issue is...
> any Idea wil be highly appreciated..
> Cheers,
> siaj
>
