Log to Database not working

pguenther

I am having trouble getting the Log to Database action to work. I am using SQL 2005 Enterprise and is seems to be an issue with the authentication but I can't figure out what I am doing wrong. I was able to get the database table created but no events are being logged. When I test the action I get "Database connection error: Login failed for user 'NT Authority\Snonymous...'. I am speciying a SQL account in the connection string and ODBC control panel. The user has dbo rights to the database.

 

Any ideas?

Kuz

Hi pguenther,

You may need to make sure that the account that the Kiwi Syslog Server (Service) is running under also has the relevant permissions to your SQL Database.  By default, the Kiwi Syslog Service runs under .\LocalSystem.

To change the Service LogOn account, go to Services Control Panel, Kiwi Syslog Server (Properties) > LogOn Account.

Please also see this KB: http://www.kiwisyslog.com/kb/error:-problems-getting-kiwi-syslog-server-to-log-to-a-database/