Hi,

First of all, I don't think that "host='sql.hidden.local\instance'" will work, but I've never tried it yet.
Secondly, there is a known bug in syslog-ng, it does not show the received error message from freetds that's why you don't see any real error message.

If you want to try it manually, you should install freetds on your computer (e.g.: apt-get install freetds on Ubuntu), than you can connect to mssql database using "tsql" command.
Just execute the following commands after connecting mssql database with tsql command:
CREATE TABLE syslogng (datetime varchar(16), host varchar(32), program varchar(32), pid varchar(8), message varchar(4096));
go

If it works, the problem is the host\instance form. If it doesn't, freetds will give you a proper error message about the reason of the problem.


2010.12.13. 16:43 keltezéssel, Shawn Cannon írta:
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 LinkedIn Facebook Twitter
My blog: My thoughts on VMworld… a week later…


______________________________________________________________________________
Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
FAQ: http://www.campin.net/syslog-ng/faq.html


--
pzolee