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.
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.
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.
For more information about the schema of the configuration file, see the Books Online topics: "Configuring the Integration Services Service" "Configuring a Windows Firewall for Integration Services Access", and "Managing Integration Services Service".
Target | Microsoft.SQLServer.2012.IntegrationServices | ||
Category | EventCollection | ||
Enabled | True | ||
Event_ID | 272 | ||
Event Source | SQLISService110 | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Remotable | True | ||
Alert Message |
| ||
Event Log | Application | ||
Comment | Mom2012ID='{9500A9D3-9854-4391-950D-C68A9841060B}';MOM2012GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_F6DA1507_12AF_11D3_AB21_00A0C98620CE_ | DataSource | Microsoft.Windows.EventProvider | Microsoft.SQLServer.SQLDefaultAccount |
GenerateAlert | WriteAction | System.Health.GenerateAlert | Default |
<Rule ID="Microsoft.SQLServer.2012.IS_Service_failed_to_load_user_defined_Configuration_file_5_Rule" Target="SQL2012Core!Microsoft.SQLServer.2012.IntegrationServices" Enabled="true" ConfirmDelivery="true" Remotable="true" Comment="Mom2012ID='{9500A9D3-9854-4391-950D-C68A9841060B}';MOM2012GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">
<Category>EventCollection</Category>
<DataSources>
<DataSource ID="_F6DA1507_12AF_11D3_AB21_00A0C98620CE_" Comment="{F6DA1507-12AF-11D3-AB21-00A0C98620CE}" TypeID="Windows!Microsoft.Windows.EventProvider" RunAs="SQL!Microsoft.SQLServer.SQLDefaultAccount">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<LogName>Application</LogName>
<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>SQLISService110</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</And>
</Expression>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="GenerateAlert" TypeID="SystemHealth!System.Health.GenerateAlert">
<Priority>1</Priority>
<Severity>2</Severity>
<AlertMessageId>$MPElement[Name="Microsoft.SQLServer.2012.IS_Service_failed_to_load_user_defined_Configuration_file_5_Rule.AlertMessage"]$</AlertMessageId>
<AlertParameters>
<AlertParameter1>$Data/EventDescription$</AlertParameter1>
</AlertParameters>
<Suppression>
<SuppressionValue/>
</Suppression>
</WriteAction>
</WriteActions>
</Rule>