SQLISService_272

Details

Product Name

SQL Server 

Product Version

10.0

Product Build Number

Event ID

272

Event Source

SQLISService100

Component

Integration Services 

Symbolic Name

DTS_MSG_SERVER_MISSING_CONFIG

Message Text

Microsoft SSIS Service configuration file does not exist.%nLoading with default settings.

Explanation

The configuration file does not exist at the specified location.

The Integration Services service relies on a configuration file for its settings. By default, the name for this configuration file is MsDtsSrvr.ini.xml, and the file is located in the folder, %ProgramFiles%\Microsoft SQL Server\100\DTS\Binn. The registry key that specifies the location of the configuration file is HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS\ServiceConfigFile.

Possible Causes

This message might appear because of one of the following problems:

  • The file has been deleted or moved.

  • The registry entry that contains the location of the file is incorrect.

  • The file is present but cannot be accessed.

User Action

Depending on why the configuration file cannot be found, you might have to take one of the following steps:

  • Locate the moved file and restore this file to the default location. Or, if the file cannot be found, use Setup to repair the Integration Services installation.

  • Ensure that the registry entry that contains the location of the file is correct.

  • Ensure that the account under which the Integration Services service is running has the following settings:

    • Permission to access and read the configuration file.

    • Permission to access and read the registry key that contains the location of the file.