none
unable to start one of the multiple instance of sql server

    Question

  • Hi Guys,

    I have 4 instances of sql server 2008 installed on windows 2008 r2 server. Today one of the instance services are stopped tha throwing the following error. we already have all the lisences.

    <Header>
      <Product>Microsoft SQL Server Reporting Services Version 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )</Product>
      <Locale>English (Australia)</Locale>
      <TimeZone>AUS Eastern Standard Time</TimeZone>
      <Path>D:\MSSQL\MSRS10.SITEDESIGN\Reporting Services\Logfiles\ReportServerService__08_07_2013_11_44_23.log</Path>
      <SystemName>PDC01SRV111</SystemName>
      <OSName>Microsoft Windows NT 6.1.7600</OSName>
      <OSVersion>6.1.7600</OSVersion>
      <ProcessID>7500</ProcessID>
    </Header>rshost!rshost!1e58!08/07/2013-11:44:23:: i INFO: CLR runtime is initialized.
    rshost!rshost!1e58!08/07/2013-11:44:23:: i INFO: Derived memory configuration based on physical memory as 4193848 KB
    appdomainmanager!DefaultDomain!1e70!08/07/2013-11:44:23:: i INFO: Entered managed ServiceMain in DefaultDomain.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing AuthenticationTypes to '4'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.
    configmanager!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Using report server internal url http://localhost:80/ReportServer_SITEDESIGN.
    configmanager!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Using report server external url http://PDC01SRV111:80/ReportServer_SITEDESIGN.
    configmanager!DefaultDomain!1f0c!08/07/2013-11:44:24:: i INFO: Using url root http://PDC01SRV111:80/ReportServer_SITEDESIGN.
    library!DefaultDomain!1f0c!08/07/2013-11:44:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
       --- End of inner exception stack trace ---
    appdomainmanager!DefaultDomain!1f0c!08/07/2013-11:44:39:: i INFO: Appdomain:2 WindowsService_0 started.
    resourceutilities!WindowsService_0!1f0c!08/07/2013-11:44:40:: i INFO: Reporting Services starting SKU: Evaluation
    library!WindowsService_0!1f0c!08/07/2013-11:44:40:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.EvaluationCopyExpiredException: The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired.  A license is now required., ;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.EvaluationCopyExpiredException: The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired.  A license is now required.
    appdomainmanager!DefaultDomain!1f0c!08/07/2013-11:44:40:: e ERROR: AppDomain WindowsService_0 failed to start. Error: Microsoft.ReportingServices.Diagnostics.Utilities.EvaluationCopyExpiredException: The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired.  A license is now required.

    Server stack trace:
       at Microsoft.ReportingServices.Diagnostics.Sku.<>c__DisplayClass1.<GetSkuFromSqlBoot>b__0()
       at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>b__0(Object state)
       at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state)
       at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback)
       at Microsoft.ReportingServices.Diagnostics.Sku.GetSkuFromSqlBoot(String instanceId, Int32& outDaysLeft)
       at Microsoft.ReportingServices.Diagnostics.Sku.GetInstalledSku(String instanceId)
       at Microsoft.ReportingServices.Diagnostics.Sku.IsFeatureEnabled(String instanceId, RestrictedFeatures feature)
       at Microsoft.ReportingServices.Diagnostics.ResourceUtilities.LogCPUAndThrottleIfNecessary()
       at Microsoft.ReportingServices.Library.ServiceAppDomain.StartService(IServiceAppDomainController appDomainController, Boolean firstStart)
       at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
       at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

    Exception rethrown at [0]:
       at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       at Microsoft.ReportingServices.Library.IServiceAppDomain.StartService(IServiceAppDomainController controller, Boolean firstStart)
       at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartServiceInNewAppDomain(Boolean firstTime)
    appdomainmanager!DefaultDomain!1f0c!08/07/2013-11:44:40:: e ERROR: Terminating the process because windows service failed to start.

    Wednesday, August 07, 2013 1:56 AM

Answers

  • System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections

    EvaluationCopyExpiredException: The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired.  A license is now required.

    Hello,

    The error message regards the Reporting Services, not the SQL Server Database Engine.

    And by the error message you have installed the Evaluation Edition of SQL Server (which is not allowed in productive environment!!!) and the evaluation period has expired. I guess it's the same for the Database Engine, therefore it has shutdown and you can't start it any longer.

    You have to purchase a license and then do an "upgrade" installation, see

    Upgrade to a Different Edition of SQL Server 2012 (Setup)

    Upgrade from SQL Server Evaluation Edition to full blown editions?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, August 07, 2013 4:07 AM
    Moderator

All replies

  • There is a memory error. Your system might be running out of memory.

    "System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException'  as specified in Configuration file."

    Try to increase memory or uninstall unwanted applications if any installed there.


    Srinivasan

    Wednesday, August 07, 2013 3:58 AM
  • System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections

    EvaluationCopyExpiredException: The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired.  A license is now required.

    Hello,

    The error message regards the Reporting Services, not the SQL Server Database Engine.

    And by the error message you have installed the Evaluation Edition of SQL Server (which is not allowed in productive environment!!!) and the evaluation period has expired. I guess it's the same for the Database Engine, therefore it has shutdown and you can't start it any longer.

    You have to purchase a license and then do an "upgrade" installation, see

    Upgrade to a Different Edition of SQL Server 2012 (Setup)

    Upgrade from SQL Server Evaluation Edition to full blown editions?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, August 07, 2013 4:07 AM
    Moderator