[syslog-ng] syslog-ng remote MSSQL databases

8 Dec 2011

      dear Srs

I need configure syslog-ng insert data on remote MSSQL database, it's
possible ?

my conf:

destination d_mssql {
    sql(type(mssql) host("ipaddres") port("1433") username("syslogng")
password("password") database("syslogng")
    table("logs")
    columns("datetime varchar(16)","host varchar(32)" ,"program
varchar(32)","pid varchar(8)","message varchar(4096)") values("$R_DATE",
"$HOST", "$PROGRAM", "$PID", "$MSGONLY")
    indexes()
    );
};

I had error when restart syslog-ng say : syntax erro

-- 
Bely Silva Junior