[syslog-ng] Microsoft SQL connect issue

[Matthew Hall]

On Monday, December 13, 2010 07:43:05 Shawn Cannon wrote:
> 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

Hello Shawn,

The first step for any DB connection is verifying that the same exact 
statements work right when executed by hand using the same user and password 
provided in the configuration to eliminate variables.

On Windows you could do this using Toad, SQL Server Admin Console, etc.

On UNIX the client for MS SQL is called sqsh, pronounced "squish":

http://packages.ubuntu.com/maverick/sqsh

This link describes the Ubuntu package. Same idea applies to Debian / RH / 
SuSE / etc.

In this case I assume your database user has a privileges issue. So you 
better take a look at the grants for that user.

Good Luck,
Matthew.