<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<title></title>
</head>
<body 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
cite="mid:AANLkTinMZP1viex1btk=KvCgZjE-pE4KECP5CfWwAiEF@mail.gmail.com"
type="cite">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">
<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 moz-do-not-send="true" 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
moz-do-not-send="true"
href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true" style="padding: 0px 0px 5px;
vertical-align: middle;"
src="http://images.wisestamp.com/linkedin.png" width="16"
border="0" height="16"></a> <a moz-do-not-send="true"
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
moz-do-not-send="true"
href="http://www.facebook.com/rolltidega72"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true" style="padding: 0px 0px 5px;
vertical-align: middle;"
src="http://images.wisestamp.com/facebook.png" width="16"
border="0" height="16"></a> <a moz-do-not-send="true"
href="http://www.facebook.com/rolltidega72"
style="text-decoration: underline;" target="_blank"><span
style="color: black;">Facebook</span></a> <a
moz-do-not-send="true" href="http://twitter.com/rolltidega"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true" style="padding: 0px 0px 5px;
vertical-align: middle;"
src="http://images.wisestamp.com/twitter.png" width="16"
border="0" height="16"></a> <a moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
src="http://s.wisestamp.com/pixel.png?p=mozilla&v=2.0.3&t=1285469003981&u=5096061&e=5721"
width="1" height="1"></span><br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
______________________________________________________________________________
Member info: <a class="moz-txt-link-freetext" href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a class="moz-txt-link-freetext" href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a class="moz-txt-link-freetext" href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
pzolee</div>
</body>
</html>