Report Server Windows service - unable to start

Hi,
For some reason I am unable to start RS Windows service. Here are the
details of Exception that I get -
****************************
System.ServiceProcess.TimeoutException: Time out has expired and the
operation has not been completed.
at
System.ServiceProcess.ServiceControoler.WaitForStatus(ServiceControllerStatus
desiredStatus, TimeSpan timeout)
at
ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(boolean start)
****************************
Both database and reporting servers are installed in a stand alone server
(MS Windows Server 2003 R2 Enterprise Edition SP1)
Any idea what could be wrong here please?
Many thanks in advance,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Hi
You have the same problem as described in the following article (it applies
in your case, except for the hotfix). Certificate Revocation List is not
accessible.
http://support.microsoft.com/kb/918644
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:D7ED0B0A-F196-4FED-89B9-5A4310B24A32@.microsoft.com...
> Hi,
> For some reason I am unable to start RS Windows service. Here are the
> details of Exception that I get -
> ****************************
> System.ServiceProcess.TimeoutException: Time out has expired and the
> operation has not been completed.
> at
> System.ServiceProcess.ServiceControoler.WaitForStatus(ServiceControllerStatus
> desiredStatus, TimeSpan timeout)
> at
> ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(boolean
> start)
> ****************************
> Both database and reporting servers are installed in a stand alone server
> (MS Windows Server 2003 R2 Enterprise Edition SP1)
> Any idea what could be wrong here please?
> Many thanks in advance,
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||Hi Mike
Thanks for your reply.
Just to clarify - I noticed that the KB article refers to SSIS service. The
same applies to Reporting services as well is it?
Once again thanks for your response.
Regards,
Harish
--
"Michael Epprecht [MSFT]" wrote:
> Hi
> You have the same problem as described in the following article (it applies
> in your case, except for the hotfix). Certificate Revocation List is not
> accessible.
> http://support.microsoft.com/kb/918644
> Regards
> --
> Mike
> This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Harish,
Thank you for using MSDN Managed Newsgroup Support.
I would like to know some additional information:
1. What's the Reporting Services Version? SQL Server 2005 or SQL Server
2000? Have you applied any Services Pack?
2. What's the result when you access the Report Server and Report Manager?
3. How do you try to start the Reporting Services?
Please let me know the result and so that I can provide further assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Many thanks for your response. Here are the answers -
1. It is SQL Server 2005 (9.00.1399.00). I have not applied any SP1 yet
2 and 3 -
I receive the error message while trying to start Report server via
Reporting Services Configuration Manager.
Also now I am getting this different error message from the Database
connection -
***************************************
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases
for databas 'DynamicsTempDB'. No entry found with that name. Make sure that
the name is entered correctly.
.......
***************************************
I am trying to get Report server connect to an existing database called
'Dynamics'.
Could you kindly let me know how to get this up and running please?
Thanks in advance,
Harish
_____________________________________
"Wei Lu" wrote:
> Hi Harish,
> Thank you for using MSDN Managed Newsgroup Support.
> I would like to know some additional information:
> 1. What's the Reporting Services Version? SQL Server 2005 or SQL Server
> 2000? Have you applied any Services Pack?
> 2. What's the result when you access the Report Server and Report Manager?
> 3. How do you try to start the Reporting Services?
> Please let me know the result and so that I can provide further assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support|||Hi Wei,
Forgot to add this - I did search for 'DynamicsTempDB' in the
rsreportserver.config file but couldn'd find this.
Regards,
Harish|||Hi Harish,
Thank you for your update.
From the description, my understanding of this is that: You get the
following error when you try to start the Reporting Services:
***************************************
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases
for databas 'DynamicsTempDB'. No entry found with that name. Make sure that
the name is entered correctly.
......
***************************************
If I misunderstood your concern, please feel free to let me know.
Firstly, please try to confirm the database DynamicsTempDB is existed in
your database server.
It seems that you are trying to connect to a Report Server database. Please
make sure the Dynamics database is a Report Server database.
Please try to use the rsconfig utility to connect to the database.
rsconfig Utility
http://msdn2.microsoft.com/en-us/library/ms162837.aspx
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a Windows -u
<MYDOMAIN\MYACCOUNT> -p <PASSWORD>
Secondly, would you please send the Reporting Service Error log to me if
the above steps does not resolve the issue?By default, the log file is
located at \Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\LogFiles. You may zip the folder and send to me directly. I
understand the information may be sensitive to you, my direct email address
is weilu@.ONLINE.microsoft.com(Please remove ONLINE when you send the
email), you may send the file to me directly and I will keep it secure.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for your assistance.
I tried your suggestion without any luck (:
As mentioned I have sent those log files in Zip format. Would very much
appreciate if you could kindly help me.
Sincerely,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
"Wei Lu" wrote:
> Secondly, would you please send the Reporting Service Error log to me if
> the above steps does not resolve the issue?By default, the log file is
> located at \Microsoft SQL Server\<SQL Server Instance>\Reporting
> Services\LogFiles. You may zip the folder and send to me directly. I
> understand the information may be sensitive to you, my direct email address
> is weilu@.ONLINE.microsoft.com(Please remove ONLINE when you send the
> email), you may send the file to me directly and I will keep it secure.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support|||Hi Harish,
Thank you for the update.
I have checked the Log file you send to me.
According to the error message, I would like to get the config file from
you.
Please provide the following config files:
\Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\ReportManager\RSWebApplication.config
\Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\ReportManager\Web.config
\Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\ReportServe\rsreportserver.config
\Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\ReportServe\web.config
Please zip these files and send to me. Thank you !
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Many thanks for your help.
As required I have mailed you the config files. Looking forward to hearing
from you.
Once again many many thanks for your assitance. Much appreciated :)
Sincerely,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
"Wei Lu" wrote:
> Hi Harish,
> Thank you for the update.
> I have checked the Log file you send to me.
> According to the error message, I would like to get the config file from
> you.
> Please provide the following config files:
> \Microsoft SQL Server\<SQL Server Instance>\Reporting
> Services\ReportManager\RSWebApplication.config
> \Microsoft SQL Server\<SQL Server Instance>\Reporting
> Services\ReportManager\Web.config
> \Microsoft SQL Server\<SQL Server Instance>\Reporting
> Services\ReportServe\rsreportserver.config
> \Microsoft SQL Server\<SQL Server Instance>\Reporting
> Services\ReportServe\web.config
> Please zip these files and send to me. Thank you !
> Sincerely,
> Wei Lu
> Microsoft Online Community Support|||Hi Harish,
Thank you for the update.
Would you please try to modify the <WebServiceIdentity> Entry in the
rsreportserver.config file?
Currently, it was <WebServiceIdentity>Local System</WebServiceIdentity>.
Please modify it to
<WebServiceIdentity>NT Authority\System</WebServiceIdentity>
After doing this, please try to start Reporting Services.
Here is an article for your reference:
You may not be able to access Reporting Services after you create an
application pool that runs under the LocalSystem account
http://support.microsoft.com/kb/907267/en-us
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Harish,
Just checking in to see if the suggestions were helpful. Please let us know
if you would like further assistance.
Have a great day!
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks to your excellent support at last I managed to resolve the problem.
Thanks for your help :)
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/|||Hi Harish,
Thank you for your update and glad to hear the information is helpful!
If you have any questions or concerns, please feel free to let us know!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei Lu!
I read this thread in its entirety and I am having the exact same problem.
However when I went to modify my rsreportserver.config file based on your
instruction below, my config file was already set to <WebServiceIdentity>NT
Authority\System</WebServiceIdentity>.
Do you have any other thoughts on how I can resolve this problem? Thanks!
Amedeo Feroce
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:%23g9GfASlGHA.4948@.TK2MSFTNGXA01.phx.gbl...
> Hi Harish,
> Thank you for the update.
> Would you please try to modify the <WebServiceIdentity> Entry in the
> rsreportserver.config file?
> Currently, it was <WebServiceIdentity>Local System</WebServiceIdentity>.
> Please modify it to
> <WebServiceIdentity>NT Authority\System</WebServiceIdentity>
> After doing this, please try to start Reporting Services.
> Here is an article for your reference:
> You may not be able to access Reporting Services after you create an
> application pool that runs under the LocalSystem account
> http://support.microsoft.com/kb/907267/en-us
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||I've seen this issue on quite a few message boards. With that being said, I
am sharing the solution that worked for me.
I simply installed SQL SERVER 2005 SP1 and re-booted the server. I opened
the reporting services configuration
tool and and reporting services was already running (keep in mind that I had
previously configured all of the other settings when I could not start
reporting services).
I hope this helps!
Amedeo
"Amedeo Feroce" <aferoce@.akdhc.com> wrote in message
news:%23HIknFtpGHA.3820@.TK2MSFTNGP05.phx.gbl...
> Hello Wei Lu!
> I read this thread in its entirety and I am having the exact same problem.
> However when I went to modify my rsreportserver.config file based on your
> instruction below, my config file was already set to
> <WebServiceIdentity>NT Authority\System</WebServiceIdentity>.
> Do you have any other thoughts on how I can resolve this problem? Thanks!
> Amedeo Feroce
> "Wei Lu" <weilu@.online.microsoft.com> wrote in message
> news:%23g9GfASlGHA.4948@.TK2MSFTNGXA01.phx.gbl...
>> Hi Harish,
>> Thank you for the update.
>> Would you please try to modify the <WebServiceIdentity> Entry in the
>> rsreportserver.config file?
>> Currently, it was <WebServiceIdentity>Local System</WebServiceIdentity>.
>> Please modify it to
>> <WebServiceIdentity>NT Authority\System</WebServiceIdentity>
>> After doing this, please try to start Reporting Services.
>> Here is an article for your reference:
>> You may not be able to access Reporting Services after you create an
>> application pool that runs under the LocalSystem account
>> http://support.microsoft.com/kb/907267/en-us
>> Hope this will be helpful!
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> ==================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>