Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS is stopping

Author  Topic 

swekik
Posting Yak Master

126 Posts

Posted - 2009-11-12 : 16:07:47
Hi,We have a SSRS & SSAS running on a box and all the settings are set to start automatically if it fails .After working fine for so many days the reporting services is stopping constantly .Does any body has seen this issue ?Is there any bug with the SSRS 2008 ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-12 : 19:23:31
What does the Event Log show?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

swekik
Posting Yak Master

126 Posts

Posted - 2009-11-13 : 10:32:23
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database

This is the only message it is giving .
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-13 : 10:43:30
Did you check the database server logs?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

swekik
Posting Yak Master

126 Posts

Posted - 2009-11-13 : 12:58:34
Thanks for responding Tara .

Yes,Nothing is there on database error log ,except changing compatibility level to 100 for report server and report server tempdb .

The databases are alreadys et to compatibility 100 .
Go to Top of Page
   

- Advertisement -