Home
  •  

SHUTDOWN is in progress.

Microsoft.SQLServer.2000.SHUTDOWN_is_in_progress (Rule)

Knowledge Base article:

Causes

SQL Server is in the process of shutting down. During shutdown only members of the sysadmin fixed server role can make new connections. A shutdown may be initiated by a person or by a program such as cluster administrator, or the shutdown may be the result of problems such as an unhandled exception.

Resolutions

Wait for the SQL Server shutdown to complete, and then restart SQL Server. Once SQL Server is restarted, try your connection again. If you must connect to SQL Server before the shutdown is complete, you can try to connect with a member of the sysadmin role; this will only succeed until a certain point in the shutdown process is reached.

If the shutdown was unexpected, review the SQL Server error logs and the event logs for related messages that can help to determine the cause of the shutdown.

Element properties:

TargetMicrosoft.SQLServer.2000.DBEngine
CategoryEventCollection
EnabledTrue
Event Source$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$
Alert GenerateTrue
Alert SeverityInformation
Alert PriorityNormal
RemotableTrue
Alert Message
SHUTDOWN is in progress.
{0}
Event LogApplication
CommentMom2005ID='{63F380D0-5491-4880-886C-5FD7C074E4C6}'

Member Modules:

ID Module Type TypeId RunAs 
EventDS DataSource Microsoft.Windows.EventProvider Default
GenerateAlert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.SQLServer.2000.SHUTDOWN_is_in_progress" Target="SQL2000Core!Microsoft.SQLServer.2000.DBEngine" Enabled="true" Comment="Mom2005ID='{63F380D0-5491-4880-886C-5FD7C074E4C6}'" Remotable="true">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="EventDS" TypeID="Windows!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <LogName>Application</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <RegExExpression>

              <ValueExpression>

                <XPathQuery>EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>MatchesMOM2005RegularExpression</Operator>

              <Pattern>^(17052|17055)$</Pattern>

            </RegExExpression>

          </Expression>

          <Expression>

            <RegExExpression>

              <ValueExpression>

                <XPathQuery>EventDescription</XPathQuery>

              </ValueExpression>

              <Operator>MatchesMOM2005BooleanRegularExpression</Operator>

              <Pattern>((^.*6005 and (not ^.*\n.*6005)) or (^.*6005.*\n.*6005)) AND (NOT ^.*[0-9]+.*6005) AND (NOT ^.*6005[0-9]+)</Pattern>

            </RegExExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="SystemHealth!System.Health.GenerateAlert">

      <Priority>1</Priority>

      <Severity>0</Severity>

      <AlertOwner>$Data/PublisherName$</AlertOwner>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServer.2000.SHUTDOWN_is_in_progress.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDescription$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>