Thanks. It ended up that I needed to make the SQL user default to that database, even though I already have the database specified in the config file. No big deal, just annoying that it seems to ignore the database setting.<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><span style="font-size: 90%;"><span style="color: gray;"></span></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 Thu, Jan 20, 2011 at 1:35 PM, Matthew Hall <span dir="ltr"><<a href="mailto:mhall@mhcomputing.net">mhall@mhcomputing.net</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 class="im"><br>
On Thu, Jan 20, 2011 at 12:39:37PM -0500, Shawn Cannon wrote:<br>
> I am trying to setup a second syslog-ng server that will be part of a load<br>
> balanced cluster. When the 2nd server tries to connect to my mssql<br>
> database, it tries to run the CREATE TABLE commands which fails because the<br>
> table already exists since the first syslog-ng server already created them.<br>
> How do I tell the 2nd server not to try the CREATE TABLE stuff so it will<br>
> start working?<br>
><br>
> Shawn Cannon<br>
><br>
> IT Professional<br>
><br>
> <a href="http://www.shawncannon.com" target="_blank">http://www.shawncannon.com</a><br>
<br>
</div>There is a dont-create-tables option in newer syslog-ngs which will fix<br>
this one.<br>
<br>
dont-create-tables: Enable this flag to prevent syslog-ng OSE from<br>
creating non-existing database tables automatically. The syslog-ng OSE<br>
application typically has to create tables if you use macros in the<br>
table names. Available in syslog-ng OSE version 3.2 and later.<br>
<br>
<a href="http://www.balabit.com/sites/default/files/documents/syslog-ng-ose-v3.2-guide-admin-en.html/index.html-single.html" target="_blank">http://www.balabit.com/sites/default/files/documents/syslog-ng-ose-v3.2-guide-admin-en.html/index.html-single.html</a><br>
<br>
HTH,<br>
<font color="#888888">Matthew.<br>
</font><div><div></div><div class="h5">______________________________________________________________________________<br>
Member info: <a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng" target="_blank">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a><br>
Documentation: <a href="http://www.balabit.com/support/documentation/?product=syslog-ng" target="_blank">http://www.balabit.com/support/documentation/?product=syslog-ng</a><br>
FAQ: <a href="http://www.campin.net/syslog-ng/faq.html" target="_blank">http://www.campin.net/syslog-ng/faq.html</a><br>
<br>
</div></div></blockquote></div><br>