I'm running Reporting Services on aWinXP machine. The reports are working
through the Preview screen but not in the browser.
When I type in the URL, http://localhost/Reports/ I get error msg:
"The Report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing. ..."
"SQL Server does not exist or access denied."
SQL server version: SQL 2000 (Developer Edition on Winodws NT 5.1 Build
2600: Service Pack 1)
Also, the following services are running: DTC, Report Server, MSSQLSERVER,
RPC.
Any idea what could be causing this error?
Thanks.One thing to understand. When you are in Visual Studio and do a preview, it
is rendering it locally. It does not use any server components (IIS, SQL
Server (if the data you are reporting off of is in SQL Server then it needs
a connection to the data that is used but RS uses SQL Server for as well -
for instance it stores the reports in SQL Server). So, just the fact that
you can do a preview has nothing to do with there being a valid install of
all the server components.
First, make sure that the configuration you are trying for is even possible.
This link tells you the different versions of RS and what is required for
the client (i.e. to develop reports) and what is required for the server to
run.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_72jq.asp
Bruce L-C
"newmem" <""> wrote in message news:exKl9rPZEHA.1000@.TK2MSFTNGP12.phx.gbl...
> I'm running Reporting Services on aWinXP machine. The reports are working
> through the Preview screen but not in the browser.
> When I type in the URL, http://localhost/Reports/ I get error msg:
> "The Report server cannot open a connection to the report server database.
A
> connection to the database is required for all requests and processing.
..."
> "SQL Server does not exist or access denied."
> SQL server version: SQL 2000 (Developer Edition on Winodws NT 5.1 Build
> 2600: Service Pack 1)
> Also, the following services are running: DTC, Report Server, MSSQLSERVER,
> RPC.
> Any idea what could be causing this error?
> Thanks.
>|||The reporting of the data is done against an Oracle database.
I had the exact configuration running on a Windows 2000 box. We had to
rebuild a new box with WinXP on it. and getting this
"rsReportServerDatabaseUnavailable" error.
Earlier the ReportServer web service could not be started due to a logon
failure error. The service was set to run under a different domain user . So
changed the logon to use the "local system account". Then the ReportServer
web service could be started. But still get the
"rsReportServerDatabaseUnavailable" error.
Do i need to run the rsocnfig utility too to repair the new credentials (i.e
with local system account) .
Any experts, pls help. Its really urgent.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eK1rR8PZEHA.3804@.TK2MSFTNGP10.phx.gbl...
> One thing to understand. When you are in Visual Studio and do a preview,
it
> is rendering it locally. It does not use any server components (IIS, SQL
> Server (if the data you are reporting off of is in SQL Server then it
needs
> a connection to the data that is used but RS uses SQL Server for as well -
> for instance it stores the reports in SQL Server). So, just the fact that
> you can do a preview has nothing to do with there being a valid install of
> all the server components.
> First, make sure that the configuration you are trying for is even
possible.
> This link tells you the different versions of RS and what is required for
> the client (i.e. to develop reports) and what is required for the server
to
> run.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_72jq.asp
> Bruce L-C
>
> "newmem" <""> wrote in message
news:exKl9rPZEHA.1000@.TK2MSFTNGP12.phx.gbl...
> > I'm running Reporting Services on aWinXP machine. The reports are
working
> > through the Preview screen but not in the browser.
> > When I type in the URL, http://localhost/Reports/ I get error msg:
> >
> > "The Report server cannot open a connection to the report server
database.
> A
> > connection to the database is required for all requests and processing.
> ..."
> > "SQL Server does not exist or access denied."
> >
> > SQL server version: SQL 2000 (Developer Edition on Winodws NT 5.1 Build
> > 2600: Service Pack 1)
> >
> > Also, the following services are running: DTC, Report Server,
MSSQLSERVER,
> > RPC.
> >
> > Any idea what could be causing this error?
> >
> > Thanks.
> >
> >
>|||When a datasource is deployed, the credentials are wiped out. Check
credentials of datasource on the report server.
"newmem" <""> wrote in message news:<exKl9rPZEHA.1000@.TK2MSFTNGP12.phx.gbl>...
> I'm running Reporting Services on aWinXP machine. The reports are working
> through the Preview screen but not in the browser.
> When I type in the URL, http://localhost/Reports/ I get error msg:
> "The Report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing. ..."
> "SQL Server does not exist or access denied."
> SQL server version: SQL 2000 (Developer Edition on Winodws NT 5.1 Build
> 2600: Service Pack 1)
> Also, the following services are running: DTC, Report Server, MSSQLSERVER,
> RPC.
> Any idea what could be causing this error?
> Thanks.|||the error occured before deploying the report. That is, just navigating to
the Report Server. Finally, fater much troubleshooting, I re-installed RS
and with proper configuration the link to the Report Server is working.
Thanks for all your help.
"kkaps" <kirtikapoor@.yahoo.com> wrote in message
news:faf24554.0407081331.6f08b5aa@.posting.google.com...
> When a datasource is deployed, the credentials are wiped out. Check
> credentials of datasource on the report server.
>
> "newmem" <""> wrote in message
news:<exKl9rPZEHA.1000@.TK2MSFTNGP12.phx.gbl>...
> > I'm running Reporting Services on aWinXP machine. The reports are
working
> > through the Preview screen but not in the browser.
> > When I type in the URL, http://localhost/Reports/ I get error msg:
> >
> > "The Report server cannot open a connection to the report server
database. A
> > connection to the database is required for all requests and processing.
..."
> > "SQL Server does not exist or access denied."
> >
> > SQL server version: SQL 2000 (Developer Edition on Winodws NT 5.1 Build
> > 2600: Service Pack 1)
> >
> > Also, the following services are running: DTC, Report Server,
MSSQLSERVER,
> > RPC.
> >
> > Any idea what could be causing this error?
> >
> > Thanks.
Sunday, February 12, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment