|
|
You're in the
sql server reporting services
group:Report Server Windows service - unable to start
sql server reporting services:
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]
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 -- [quoted text, click to view] "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 >
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. [quoted text, click to view] "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 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 _____________________________________ [quoted text, click to view] "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
Hi Wei,
Forgot to add this - I did search for 'DynamicsTempDB' in the rsreportserver.config file but couldn'd find this. Regards,
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/ [quoted text, click to view] "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/ [quoted text, click to view] "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
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]
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 [quoted text, click to view] "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 [quoted text, click to view] "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. >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |