Monitor unlimited number of servers
Filter log events
Create email and web-based reports

Direct access to Microsoft articles
Customized keywords for major search engines
Access to premium content

Event ID: 274 Source: SQLISService100

Level
Description
Microsoft SSIS Service:
Registry setting specifying configuration file does not exist.
Attempting to load default config file.
Comments
 
From a support forum: In your registry, go to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\ServiceConfigFile
or
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ServiceConfigFile

if value is empty then add in:
C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml
Installing Service Pack 1 removes data from
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS\ServiceConfigFile

Fresh install of MS SQL server 2008 R2 Standard RTM (with SSIS selected) populates the above registry key with "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml"

Installing Service Pack 1 for MS SQL Server 2008 R2 REMOVES the data, causing SSIS to log Event 274 in the Aplication log.

According to Microsoft, this behavior as “By Design.” Because the default path is not required, the behavior was changed in SP1 to remove it from the registry rather than including it. To remove the warning message, you can re-add the default path to the registry.

Windows Event Log Analysis Splunk App

Build a great reporting interface using Splunk, one of the leaders in the Security Information and Event Management (SIEM) field, linking the collected Windows events to www.eventid.net.

Read more...

 

Cisco ASA Log Analyzer Splunk App

Obtain enhanced visibility into Cisco ASA firewall logs using the free Firegen for Cisco ASA Splunk App. Take advantage of dashboards built to optimize the threat analysis process.

Read more...