July 14, 2015 at 1:36 pm
Hello everyone,
I hope everyone is doning well,
Iam facing one SSRS 2005 issue on Prod environment.
Please see my observations below.
1.Reporting services database is not configured on the instance.
2.im unable to connec to SSRS instance via SSMS.
3.Im getting the below error while opening the Reporting services config manager.
There was an error while switching panels.the most likely casue is an error retrieving WMI properties.the execution details are:
A WMI ERROR has occured and no additional error information is available.
4.SSRS Services running fine.
few times service were restarted itself but i need to know why the services failed.
I) The SQL Server Reporting Services (MSSQLSERVER) service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.
II) The SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 60000 milliseconds: Restart the service.
Please let me know what needs to be check from our end.
anyone know why the Service itself can be restarted ?
Please, give me some information and suggestions on this so that i can proceed further.
Thanks in advance!!
Thanks & Regards,
DBA
SQL server DBA
July 14, 2015 at 1:49 pm
Is the server up to the latest and greatest MS patches for the OS and for SQL Server?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 15, 2015 at 12:10 am
Yes Latest service pack for sql server 2005 is sp4.
But why the services restarted itself? any idea? please help me...
SQL server DBA
July 15, 2015 at 9:24 am
Database admin(DBA) (7/15/2015)
Yes Latest service pack for sql server 2005 is sp4.But why the services restarted itself? any idea? please help me...
What about the OS part of that question?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply