[syslog-ng] Microsoft SQL connect issue

[Shawn Cannon]

When a Microsoft SQL connection is attempted, I get the following errors.  I
am trying to connect to a names instance of MS SQL over TCP 1785.  Any
ideas?  Thanks....

Dec 13 10:33:23 syslog01 syslog-ng[27963]: Error running SQL query;
type='freetds', host='sql.hidden.local\instance', port='1785', user='user',
database='syslog', error='', query='CREATE TABLE syslogng (datetime
varchar(16), host varchar(32), program varchar(32), pid varchar(8), message
varchar(4096))'
Dec 13 10:33:23 syslog01 syslog-ng[27963]: Error creating table, giving up;
table='syslogng'
Dec 13 10:33:23 syslog01 syslog-ng[27963]: Error checking table,
disconnecting from database, trying again shortly; time_reopen='60'

Shawn Cannon

IT Professional

http://www.shawncannon.com


Contact Me <http://www.linkedin.com/pub/shawn-cannon/5/84/81a>
LinkedIn<http://www.linkedin.com/pub/shawn-cannon/5/84/81a>
<http://www.facebook.com/rolltidega72>
Facebook<http://www.facebook.com/rolltidega72>
<http://twitter.com/rolltidega> Twitter <http://twitter.com/rolltidega>
My blog: My thoughts on VMworld… a week later…<http://www.shawncannon.com/?p=19>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20101213/9f9ec800/attachment.htm