Report Server Windows Service error: The report server has encountered a configuration error.

  • We are getting Report Server Windows Service error every 12 hours in application event log.

    Log Name: Application

    Source: Report Server Windows Service (MSSQLSERVER)

    Date: 30/11/2010 07:37:55

    Event ID: 140

    Task Category: Startup/Shutdown

    Level: Error

    Keywords: Classic

    User: N/A

    Computer: xxxxxxxxxxxxx

    Description:

    The application domain WindowsService_7 failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

    at Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()

    at Microsoft.ReportingServices.Library.ConnectionConfig..ctor()

    at Microsoft.ReportingServices.Library.ConnectionManager..ctor()

    at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart).

    Event Xml:

    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

    <System>

    <Provider Name="Report Server Windows Service (MSSQLSERVER)" />

    <EventID Qualifiers="0">140</EventID>

    <Level>2</Level>

    <Task>9</Task>

    <Keywords>0x80000000000000</Keywords>

    <TimeCreated SystemTime="2010-11-30T07:37:55.000Z" />

    <EventRecordID>16059</EventRecordID>

    <Channel>Application</Channel>

    <Computer>xxxxxxxxxxxxx</Computer>

    <Security />

    </System>

    <EventData>

    <Data>WindowsService_7</Data>

    <Data>Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

    at Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()

    at Microsoft.ReportingServices.Library.ConnectionConfig..ctor()

    at Microsoft.ReportingServices.Library.ConnectionManager..ctor()

    at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart)</Data>

    </EventData>

    </Event>

    Report Server log:

    <Header>

    <Product>Microsoft SQL Server Reporting Services Version 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )</Product>

    <Locale>English (United Kingdom)</Locale>

    <TimeZone>GMT Standard Time</TimeZone>

    <Path>C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__11_30_2010_07_37_53.log</Path>

    <SystemName>XXXXX</SystemName>

    <OSName>Microsoft Windows NT 6.0.6001 Service Pack 1</OSName>

    <OSVersion>6.0.6001</OSVersion>

    <ProcessID>1556</ProcessID>

    </Header>rshost!rshost!15a4!11/30/2010-07:37:53:: w WARN: Endpoint 2 is enabled but no url is registered for vdir=, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer.

    rshost!rshost!15a4!11/30/2010-07:37:53:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager.

    rshost!rshost!15a4!11/30/2010-07:37:53:: i INFO: Endpoint 4 is disabled and no url is registered vdir=, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.

    rshost!rshost!8ec!11/30/2010-07:37:53:: i INFO: Derived memory configuration based on physical memory as 1047376 KB

    servicecontroller!DefaultDomain!8ec!11/30/2010-07:37:53:: i INFO: Recycling the service from the default domain

    appdomainmanager!WindowsService_7!9e8!11/30/2010-07:37:55:: e ERROR: Appdomain:9 WindowsService_7 failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

    at Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()

    at Microsoft.ReportingServices.Library.ConnectionConfig..ctor()

    at Microsoft.ReportingServices.Library.ConnectionManager..ctor()

    at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart).

    rshost!rshost!8ec!11/30/2010-07:37:55:: i INFO: Application domain type WindowsService statistics: created: 8, unloaded: 8, failed: 0, timed out: 0.

    appdomainmanager!DefaultDomain!8ec!11/30/2010-07:37:55:: i INFO: Appdomain:10 WindowsService_8 started.

    resourceutilities!WindowsService_8!8ec!11/30/2010-07:37:56:: i INFO: Reporting Services starting SKU: Standard

    resourceutilities!WindowsService_8!8ec!11/30/2010-07:37:56:: i INFO: Evaluation copy: 0 days left

    resourceutilities!WindowsService_8!8ec!11/30/2010-07:37:56:: i INFO: Running on 2 physical processors, 2 logical processors

    servicecontroller!WindowsService_7!8ec!11/30/2010-07:37:56:: i INFO: Service controller exiting.

    appdomainmanager!DefaultDomain!8ec!11/30/2010-07:37:56:: i INFO: Appdomain:9 unregistered.

    appdomainmanager!DefaultDomain!8ec!11/30/2010-07:37:56:: i INFO: Appdomain:9 WindowsService_7 unloading.

    appdomainmanager!DefaultDomain!15a4!11/30/2010-07:37:56:: i INFO: AppDomain:9 0 pending unload(s)

    library!WindowsService_8!9e8!11/30/2010-07:37:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. , No DSN present in configuration file;

    Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

    library!WindowsService_8!9e8!11/30/2010-07:37:56:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

    at Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()

    at Microsoft.ReportingServices.Library.ConnectionConfig..ctor()

    at Microsoft.ReportingServices.Library.ConnectionManager..ctor()

    at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart)

    library!WindowsService_8!9e8!11/30/2010-07:37:56:: e ERROR: ServiceStartThread: Attempting to start service again...

    Please, could any one help me fix this?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply