MSSQL Integration Services on Windows: IS Service failed to load user defined Configuration file

Microsoft.SQLServer.IS.Windows.IS_Service_failed_to_load_user_defined_Configuration_file_5_Rule (Rule)

The configuration file for the Integration Services service could not be loaded, when the services was started. By default, this file is named MSDtsSrvr.ini.xml. However, Integration Services can be configured by a registry setting to use any file name and file location.

Knowledge Base article:

Summary

Causes

The configuration file could not be loaded because file could not be found or the specified file does not have the expected format. The file may be corrupted or the network share on which the file is located, is not accessible.

Resolutions

Provide either a configuration file in the default location, Microsoft\SQL Server\90\DTBinn, or the location that is indicated in the registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\ServiceConfigFiledefault

Verify that the configuration file is an XML file that adheres to the specified schema.

External

For more information about the schema of the configuration file, see the Docs Online topics: "Configuring the Integration Services Service", "Configuring a Windows Firewall for Integration Services Access", and "Managing Integration Services Service".

Overridable Parameters

Name	Description	Default Value
Allow Proxying	Specifies whether the module should collect events that do not originate from the computer that is specified in the ComputerName parameter.	No
Enabled	Enables or disables the workflow.	Yes
Priority	Defines Alert Priority.	1
Severity	Defines Alert Severity.	2

Element properties:

Target

Microsoft.SQLServer.IS.Windows.LocalInstance

Category

EventCollection

Enabled

True

Alert Generate

True

Alert Severity

Error

Alert Priority

Normal

Remotable

True

Alert Message

MSSQL Integration Services on Windows: IS Service failed to load user defined Configuration file

Event ID: {0}. Microsoft SSIS Service configuration file does not exist. Loading with default settings.

Comment

Mom2017ID='{9500A9D3-9854-4391-950D-C68A9841060B}';MOM2017GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

ID	Module Type	TypeId	RunAs
_F6DA1507_12AF_11D3_AB21_00A0C98620CE_	DataSource	Microsoft.SQLServer.IS.Windows.EventProvider	Default
GenerateAlert	WriteAction	System.Health.GenerateAlert	Default

Source Code:

<Rule ID="Microsoft.SQLServer.IS.Windows.IS_Service_failed_to_load_user_defined_Configuration_file_5_Rule" Target="Microsoft.SQLServer.IS.Windows.LocalInstance" Enabled="true" ConfirmDelivery="true" Remotable="true" Comment="Mom2017ID='{9500A9D3-9854-4391-950D-C68A9841060B}';MOM2017GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F6DA1507_12AF_11D3_AB21_00A0C98620CE_" TypeID="Microsoft.SQLServer.IS.Windows.EventProvider" Comment="{F6DA1507-12AF-11D3-AB21-00A0C98620CE}">

      <ComputerName>$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/NetBiosComputerName$</ComputerName>

      <LogName>Application</LogName>

      <AllowProxying>false</AllowProxying>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>272</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>SQLISService$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$0</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

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

      <Priority>1</Priority>

      <Severity>2</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServer.IS.Windows.IS_Service_failed_to_load_user_defined_Configuration_file_5_Rule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDisplayNumber$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>