The report server cannot open a connection to the report server database
Hello,
I am a newbie to sql server 2005 Reporting services. After installation of sql server 2005 beta 2,
I tried typinghttp://localhost/ReportServer to check if the reportserver is working correctly, but
I am getting this 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
- Shared Memory Provider: The specified module could not be found.
I am not sure where is the error and what to do? Please help me out!
Thanks a zillion in advance.
[1346 byte] By [
Sankar07] at [2008-2-14]
Since Beta 2, we have released a number of CTP releases of SQL Server 2005. I would go ahead and try to obtain the latest CTP rather than testing on Beta 2 (it is very out of date at this point and we're not supporting it in the newsgroups/ discussion forums anymore). If you're an MSDN subscriber, you should have access to the CTP releases of SQL Server 2005.
-Lukasz
Hello,
Wanted to let you know that..got that error fixed...
I was told that , Reporting services sometimes doesnt know to associate instances when you install and we have to do it manually..
so in command prompt, i typed
rsconfig -c -iMSSQLSERVER -slocalhost -dReportServer -aWindows
and then it worked..
Thanks,
If you chose the "Install but do not configure" option in report server setup, that is true.
There are also cases where when you choose "Default configuration" in seutp, you'll see this behavior. Usually it has to do with an existing database named "ReportServer$InstanceName" already in the folder where we try to create our database by default. Rather than rollback setup, we figure you might just want to configure it after.
Also, in SQL Server 2005, you can do this through a UI tool instead of using rsconfig.exe. Under Start->All Program->Microsoft SQL Server June CTP->Configuration Tools choose "Reporting Services Configuration"
-Lukasz
