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&amp;v=2.0.3&amp;t=1285469003981&amp;u=5096061&amp;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">&lt;<a href="mailto:pzolee@balabit.hu">pzolee@balabit.hu</a>&gt;</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&#39;t think that &quot;host=&#39;sql.hidden.local\instance&#39;&quot;
    will work, but I&#39;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&#39;s why you don&#39;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 &quot;tsql&quot; 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&#39;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=&#39;freetds&#39;, host=&#39;sql.hidden.local\instance&#39;,
      port=&#39;1785&#39;, user=&#39;user&#39;, database=&#39;syslog&#39;, error=&#39;&#39;,
      query=&#39;CREATE TABLE syslogng (datetime varchar(16), host
      varchar(32), program varchar(32), pid varchar(8), message
      varchar(4096))&#39;<br>
      Dec 13 10:33:23 syslog01 syslog-ng[27963]: Error creating table,
      giving up; table=&#39;syslogng&#39;<br>
      Dec 13 10:33:23 syslog01 syslog-ng[27963]: Error checking table,
      disconnecting from database, trying again shortly;
      time_reopen=&#39;60&#39;<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>