SQL Server 2008 Feb CTP Report Services Failed to start

SQL Server 2008 Feb CTP Report Services Failed to start by velocitygt

Closed

as Fixed

Type:	Bug
ID:	332969
Opened:	3/13/2008 6:11:37 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

I have installed and uninstalled all SQL 2008 Feb CTP components multiple times, and still not once was I able to get Reporting Services to run. The service just will not start.

The error logged was:
Log Name:     Application
Source:        Application Error
Date:         3/13/2008 9:04:51 PM
Event ID:     1000
Task Category: (100)
Level:         Error
Keywords:     Classic
User:         N/A
Computer:     James-PC.DOMAIN06
Description:
Faulting application ReportingServicesService.exe, version 2007.100.1300.13, time stamp 0x47ac1741, faulting module kernel32.dll, version 6.0.6000.16386, time stamp 0x4549bd80, exception code 0xc0000005, fault offset 0x00047a23, process id 0x1288, application start time 0x01c8856f67b6ceec.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="Application Error" />
    <EventID Qualifiers="0">1000</EventID>
    <Level>2</Level>
    <Task>100</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2008-03-14T01:04:51.000Z" />
    <EventRecordID>42082</EventRecordID>
    <Channel>Application</Channel>
    <Computer>James-PC.DOMAIN06</Computer>
    <Security />
</System>
<EventData>
    <Data>ReportingServicesService.exe</Data>
    <Data>2007.100.1300.13</Data>
    <Data>47ac1741</Data>
    <Data>kernel32.dll</Data>
    <Data>6.0.6000.16386</Data>
    <Data>4549bd80</Data>
    <Data>c0000005</Data>
    <Data>00047a23</Data>
    <Data>1288</Data>
    <Data>01c8856f67b6ceec</Data>
</EventData>
</Event>

and the Reporting Services Configuration Manager Logged the following:
System.InvalidOperationException: Cannot start service ReportServer on computer 'JAMES-PC'. ---> System.ComponentModel.Win32Exception: The service did not respond to the start or control request in a timely fashion
--- End of inner exception stack trace ---
at System.ServiceProcess.ServiceController.Start(String[] args)
at System.ServiceProcess.ServiceController.Start()
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

Details (expand)

English

SQL Server 2008 February CTP

Reporting Services

Windows Vista

US English

Following the wizard to Install

The error logged was:
Log Name:     Application
Source:        Application Error
Date:         3/13/2008 9:04:51 PM
Event ID:     1000
Task Category: (100)
Level:         Error
Keywords:     Classic
User:         N/A
Computer:     James-PC.DOMAIN06
Description:
Faulting application ReportingServicesService.exe, version 2007.100.1300.13, time stamp 0x47ac1741, faulting module kernel32.dll, version 6.0.6000.16386, time stamp 0x4549bd80, exception code 0xc0000005, fault offset 0x00047a23, process id 0x1288, application start time 0x01c8856f67b6ceec.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="Application Error" />
    <EventID Qualifiers="0">1000</EventID>
    <Level>2</Level>
    <Task>100</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2008-03-14T01:04:51.000Z" />
    <EventRecordID>42082</EventRecordID>
    <Channel>Application</Channel>
    <Computer>James-PC.DOMAIN06</Computer>
    <Security />
</System>
<EventData>
    <Data>ReportingServicesService.exe</Data>
    <Data>2007.100.1300.13</Data>
    <Data>47ac1741</Data>
    <Data>kernel32.dll</Data>
    <Data>6.0.6000.16386</Data>
    <Data>4549bd80</Data>
    <Data>c0000005</Data>
    <Data>00047a23</Data>
    <Data>1288</Data>
    <Data>01c8856f67b6ceec</Data>
</EventData>
</Event>

and the Reporting Services Configuration Manager Logged the following:
System.InvalidOperationException: Cannot start service ReportServer on computer 'JAMES-PC'. ---> System.ComponentModel.Win32Exception: The service did not respond to the start or control request in a timely fashion
--- End of inner exception stack trace ---
at System.ServiceProcess.ServiceController.Start(String[] args)
at System.ServiceProcess.ServiceController.Start()
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

Report Services to start

File Name	Submitted By	Submitted On	File Size
James-PC_20080313_1926_RS_Cpu32_1.log (restricted)	velocitygt	3/27/2008	-
James-PC_20080313_1926_SqlRsFx_Cpu32_1.log (restricted)	velocitygt	3/27/2008	-

Posted by Microsoft on 4/11/2008 at 11:45 AM

I've followed up on this and found there is no way to workaround the issue by simply disabling Kaspersky Anti-Virus. Unfortunately, until the next CTP of SQL 2008 is available (in several months), you'll have to uninstall Kaspersky Anti-Virus in order to evaluate SSRS.

I have resolved this issue as a duplicate of the issue we fixed. You should expect to see on the connect website that the issue has been fixed.

Thanks,
-Lukasz

Posted by Microsoft on 4/10/2008 at 7:07 PM

Thank you for the information. The issue we fixed recently was due to Kaspersky Anti-Virus. I will try to determine if there is a known workaround.

Thanks,
-Lukasz

Posted by velocitygt on 4/10/2008 at 6:26 AM

I am using Kaspersky 6.0. I had disabled all of it's services as requested, and tried to manually start SSRS, but it failed just like before, with the same errors.

Posted by Microsoft on 4/9/2008 at 2:53 PM

Can you tell me if there are is any anti-virus software running on this computer? We have seen an issue where specific anti-virus software can cause the SSRS service to fail to start. A fix for the anti-virus issue will be availalbe in a future CTP of SQL Server 2008.

I'd like to try to determine if your issue is the same, or different.

Can you try:
1) disabling (stop) your anti-virus
2) try to start your SSRS service
3) enable (start) your anti-virus

Please let me know if your SSRS service starts correctly.

Thanks,
-Lukasz

Posted by velocitygt on 4/8/2008 at 7:14 AM

The service is set to start automatically, and every time I manually start it, the following is recorded in the Application Log:
Faulting application ReportingServicesService.exe, version 2007.100.1300.13, time stamp 0x47ac1741, faulting module ntdll.dll, version 6.0.6001.18000, time stamp 0x4791a7a6, exception code 0xc0000005, fault offset 0x0003d0f4, process id 0x1a68, application start time 0x01c8998235fcfe70

Posted by Microsoft on 4/7/2008 at 3:26 PM

Thank you for confirming there are no log files.

Can you check the Application Event log on the computer for any errors related to starting the SSRS service?

Can you use service control manager (start -> Run -> services.msc) to manually restart the SSRS service? What error message do you get? Is the service set to start automatically or manually, or is it disabled?

Thanks,
-Lukasz

Posted by velocitygt on 4/3/2008 at 11:41 AM

The "%ProgramFiles%\Microsoft SQL Server\\Reporting Services\LogFiles" folder is empty, there are no logs. And I only have 1 instance of SQL SERVER installed, so there's no mistake on where the folder should be...

Posted by Microsoft on 4/2/2008 at 6:38 PM

We will need additional non-setup related logs to determine why the service is not starting appropriately. Can you please provide the logs under %ProgramFiles%\Microsoft SQL Server\<instancename>\Reporting Services\LogFiles.

Thank you,
-john

Posted by Microsoft on 3/30/2008 at 10:16 PM

Thank you for the logs.

We have re-activated this bug and are investigating the information you have provided.

thanx,
Prash

Posted by velocitygt on 3/30/2008 at 5:08 AM

I have uploaded the logs as requested, how come the status changed to "won't fix" without any additional comments?

Posted by Microsoft on 3/24/2008 at 6:37 PM

Thank you for filing this bug.

Can you please attach the setup logs to the bug? These can be found under the folder - %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LOG.

thanx,
Prash