Naturally, as soon as I posted this, I thought of something else to check - credentials for the service did not have rights to the database. Duh. Changed the credentials for the service and all is well.
Trying to syslog an ASA 5510 to SQL Server. I have SysLog2ODBC running on a domain workstation. The configuration file is as follows:
[Server]
BindToIP=10.0.0.33
Port=514
[Logging]
LogToFile=1
LogFilePath=C:\Program Files\Syslog\syslog.log
MinSeverity=7
[ODBC]
ConnectionString=DSN=SysLogDatabase
SQLStatement=INSERT INTO SysLogEvents( Severity, Msg ) VALUES ( ?, ? ...
