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?<br>
<br clear="all"><span style="font-size: 13.3px; font-family: Verdana,Arial,Helvetica,sans-serif;"><div style="border: 1px solid rgb(229, 229, 229); background-color: rgb(248, 248, 248); padding: 0.8em 0.8em 0.3em;"><div style="margin: 0pt 0pt 8px;">
<p style="margin: 0pt;">Shawn Cannon</p>
<p style="margin: 0pt;">IT Professional</p>
<p style="margin: 0pt;"><a title="My Web Site" href="http://www.shawncannon.com/" target="_blank">http://www.shawncannon.com</a></p>
<p style="margin: 0pt;"> </p></div><span style="color: gray;">Contact Me</span> <a href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a" style="text-decoration: underline;" target="_blank"><img style="padding: 0px 0px 5px; vertical-align: middle;" src="http://images.wisestamp.com/linkedin.png" border="0" height="16" width="16"></a> <a href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a" style="text-decoration: underline;" target="_blank"><span style="color: black;">LinkedIn</span></a> <a href="http://www.facebook.com/rolltidega72" style="text-decoration: underline;" target="_blank"><img style="padding: 0px 0px 5px; vertical-align: middle;" src="http://images.wisestamp.com/facebook.png" border="0" height="16" width="16"></a> <a href="http://www.facebook.com/rolltidega72" style="text-decoration: underline;" target="_blank"><span style="color: black;">Facebook</span></a> <a href="http://twitter.com/rolltidega" style="text-decoration: underline;" target="_blank"><img style="padding: 0px 0px 5px; vertical-align: middle;" src="http://images.wisestamp.com/twitter.png" border="0" height="16" width="16"></a> <a href="http://twitter.com/rolltidega" style="text-decoration: underline;" target="_blank"><span style="color: black;">Twitter</span></a><br>
<span style="font-size: 90%;"><span style="color: gray;">My blog: </span> <a href="http://www.shawncannon.com/?p=19" target="_blank"><span style="color: rgb(0, 0, 238); text-decoration: underline;">My thoughts on VMworld… a week later…</span></a></span><br>
</div><img src="http://s.wisestamp.com/pixel.png?p=mozilla&v=2.0.3&t=1285469003981&u=5096061&e=5721" height="1" width="1"></span><br>
<br><br><div class="gmail_quote">On Mon, Dec 13, 2010 at 11:36 AM, Zoltán Pallagi <span dir="ltr"><<a href="mailto:pzolee@balabit.hu">pzolee@balabit.hu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
First of all, I don't think that "host='sql.hidden.local\instance'"
will work, but I've never tried it yet.<br>
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.<br>
<br>
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.<br>
Just execute the following commands after connecting mssql database
with tsql command:<br>
CREATE TABLE syslogng (datetime varchar(16), host varchar(32),
program varchar(32), pid varchar(8), message varchar(4096));<br>
go<br>
<br>
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.<br>
<br>
<br>
2010.12.13. 16:43 keltezéssel, Shawn Cannon írta:
<blockquote type="cite"><div class="im">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....<br>
<br>
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))'<br>
Dec 13 10:33:23 syslog01 syslog-ng[27963]: Error creating table,
giving up; table='syslogng'<br>
Dec 13 10:33:23 syslog01 syslog-ng[27963]: Error checking table,
disconnecting from database, trying again shortly;
time_reopen='60'<br>
<br clear="all">
</div><span style="font-size: 13.3px; font-family: Verdana,Arial,Helvetica,sans-serif;">
<div style="border: 1px solid rgb(229, 229, 229); background-color: rgb(248, 248, 248); padding: 0.8em 0.8em 0.3em;">
<div style="margin: 0pt 0pt 8px;">
<p style="margin: 0pt;">Shawn Cannon</p>
<p style="margin: 0pt;">IT Professional</p>
<p style="margin: 0pt;"><a title="My
Web Site" href="http://www.shawncannon.com/" target="_blank">http://www.shawncannon.com</a></p>
<p style="margin: 0pt;"> </p>
</div><div class="im">
<span style="color: gray;">Contact Me</span> <a href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a" style="text-decoration: underline;" target="_blank"><img src="" style="padding: 0px 0px 5px; vertical-align: middle;" border="0" height="16" width="16"></a> <a href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a" style="text-decoration: underline;" target="_blank"><span style="color: black;">LinkedIn</span></a> <a href="http://www.facebook.com/rolltidega72" style="text-decoration: underline;" target="_blank"><img src="" style="padding: 0px 0px 5px; vertical-align: middle;" border="0" height="16" width="16"></a> <a href="http://www.facebook.com/rolltidega72" style="text-decoration: underline;" target="_blank"><span style="color: black;">Facebook</span></a> <a href="http://twitter.com/rolltidega" style="text-decoration: underline;" target="_blank"><img src="" style="padding: 0px 0px 5px; vertical-align: middle;" border="0" height="16" width="16"></a> <a href="http://twitter.com/rolltidega" style="text-decoration: underline;" target="_blank"><span style="color: black;">Twitter</span></a><br>
<span style="font-size: 90%;"><span style="color: gray;">My
blog: </span> <a href="http://www.shawncannon.com/?p=19" target="_blank"><span style="color: rgb(0, 0, 238); text-decoration: underline;">My thoughts on VMworld… a week later…</span></a></span><br>
</div></div>
<img src="" height="1" width="1"></span><br>
<pre><fieldset></fieldset>
______________________________________________________________________________
Member info: <a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng" target="_blank">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a href="http://www.balabit.com/support/documentation/?product=syslog-ng" target="_blank">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a href="http://www.campin.net/syslog-ng/faq.html" target="_blank">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
<br>
<br>
<div>-- <br>
pzolee</div>
</div>
</blockquote></div><br>