Home
  •  

ConfigMgr 2007 依存服務失敗: MSSQLSERVER 無法登入

SMSv4_dependent_service_failure__MSSQLSERVER_was_unable_to_log_on_3_Rule (Rule)

Knowledge Base article:

摘要

由於使用者認證及密碼不再有效，所以無法啟動服務。因此相依服務及用戶端將無法再繼續使用此服務。此服務預設會以本機系統帳戶登入。用以登入的帳戶可能已從本機系統變更為其他帳戶。

原因

用以啟動此服務之帳戶的認證無效，或其權限不足而無法啟動服務。

其他

此警示最好交由 Configuration Manager 系統管理員處理。

範例事件：

下列錯誤致使 %1 服務無法以 %2 的身分使用目前所設定的密碼登入：%n%3%n%n 為確保服務設定正確，請使用 Microsoft Management Console (MMC) 的 [服務] 嵌入式管理單元。

外部

如需更多協助，請參閱 Configuration Manager 2007 支援網站 (英文) 上，Configuration Manager 2007 網站支援區段中的其他支援選項清單。

Element properties:

TargetMicrosoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Software_Update_Point_Servers_Installation
CategoryEventCollection
EnabledFalse
Alert GenerateTrue
Alert SeverityError
Alert PriorityLow
RemotableTrue
Alert MessageSMSv4_dependent_service_failure__MSSQLSERVER_was_unable_to_log_on_3_Rule.AllertMessageBackwardCompatibility
Event LogSystem
CommentMom2005ID='{FF70787A-6264-4764-9A98-47D96ED71B82}';MOM2005ComputerGroupID={2C48D0EE-B910-4E4F-99E4-5A95F1C1F24E}

Member Modules:

ID Module Type TypeId RunAs 
_907D4578_146C_11D3_AB21_00A0C98620CE_ DataSource Microsoft.Windows.EventProvider Default
CollectEventData WriteAction Microsoft.SystemCenter.CollectEvent Default
CollectEventDataWarehouse WriteAction Microsoft.SystemCenter.DataWarehouse.PublishEventData Default
GenerateAlert WriteAction System.Mom.BackwardCompatibility.AlertResponse Default

Source Code:

<Rule ID="SMSv4_dependent_service_failure__MSSQLSERVER_was_unable_to_log_on_3_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Software_Update_Point_Servers_Installation" Enabled="false" ConfirmDelivery="true" Comment="Mom2005ID='{FF70787A-6264-4764-9A98-47D96ED71B82}';MOM2005ComputerGroupID={2C48D0EE-B910-4E4F-99E4-5A95F1C1F24E}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_907D4578_146C_11D3_AB21_00A0C98620CE_" Comment="{907D4578-146C-11D3-AB21-00A0C98620CE}" TypeID="WindowsLibrary!Microsoft.Windows.EventProvider">

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

      <LogName>System</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="String">PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>Service Control Manager</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="String">Params/Param[1]</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>MSSQLSERVER</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>7038</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.AlertResponse">

      <AlertGeneration>

        <GenerateAlert>true</GenerateAlert>

        <Owner/>

        <Description>

            $Data/LoggingComputer$

           - ConfigMgr 2007 dependent service failure: MSSQLSERVER was unable to log on.



The MSSQLSERVER service running on 

            $Data/LoggingComputer$

           was detected as stopped at 

            $Data/@time$

          .</Description>

        <AlertLevel>70</AlertLevel>

        <ResolutionState/>

        <Source>

            $Data/PublisherName$

          </Source>

        <Name>ConfigMgr 2007 dependent service failure: MSSQLSERVER was unable to log on</Name>

      </AlertGeneration>

      <InvokerType>0</InvokerType>

    </WriteAction>

    <WriteAction ID="CollectEventData" TypeID="SystemCenterLibrary!Microsoft.SystemCenter.CollectEvent"/>

    <WriteAction ID="CollectEventDataWarehouse" TypeID="DataWarehouseLibrary!Microsoft.SystemCenter.DataWarehouse.PublishEventData"/>

  </WriteActions>

</Rule>