[syslog-ng] Microsoft SQL connect issue

[Matthew Hall]

On Mon, Dec 13, 2010 at 12:19:03PM -0500, Shawn Cannon wrote:
> I meant I ran tsql.  :-)
> 
> Shawn Cannon
> 
> IT Professional
> 
> > OK I installed it ans ran TDS using sql.hidden.local and the port number
> > and I was able to create the table.  I changed my syslogng config file to
> > this same setting, yet it still gives me an error.  I left the table in the
> > database that was created but even that did not help.  Any ideas?

There have been some bugs in the past where syslog-ng was not always 
connecting to the database correctly on the proper ports, etc. However 
in your case this could only apply if something was also listening on 
the default port I would assume, since it seemed like it had connected. 
Although as one of the other posters had pointed out there could be an 
inaccurate error message as well. Perhaps you could verify it's 
connecting properly to the DB using Wireshark?

Was the tsql / sqsh / etc. based testing performed using the same 
machine as the syslog-ng setup is running?

Matthew.