Spam Filter ISP Forums : Quarantine DB not active

Spam Filter ISP Forums : Quarantine DB not active https://www.logsat.com/spamfilter/forums/ Mon, 13 Jul 2026 02:46:44 +0000 Tue, 15 Jan 2008 21:46:05 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=6335 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Quarantine DB not active : For documentation purposes, and...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11537&title=quarantine-db-not-active#11537 Author: LogSat
Subject: 6335
Posted: 15 January 2008 at 9:46pm

For documentation purposes, and to help solve similar problems - tere were two issues.
1 - The TCP/IP protocol was disabled in SQL Server, leaving only Named Pipes operational. The "UDL Test" would succeed as it uses named Pipes, but SpamFilter uses TCP/IP to communicate with SQL.

2. After enabling TCP/IP, SQL server still would not use TCP for communications. This turned out to be a Microsoft bug. The symptom and resolution were the same as in this KB article: http://support.microsoft.com/kb/306865

]]> Tue, 15 Jan 2008 21:46:05 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11537&title=quarantine-db-not-active#11537 <![CDATA[Quarantine DB not active : Randy,If you can email us with...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11523&title=quarantine-db-not-active#11523 Author: LogSat
Subject: 6335
Posted: 12 January 2008 at 2:25pm

Randy,

If you can email us with information on how we can remote into your server (Remote Destop, VPN, PCAnywhere, etc), we can try to access your server to see what we can do.
]]> Sat, 12 Jan 2008 14:25:08 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11523&title=quarantine-db-not-active#11523 <![CDATA[Quarantine DB not active : Sorry I dodn't give you all...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11518&title=quarantine-db-not-active#11518 Author: rdemeyer
Subject: 6335
Posted: 11 January 2008 at 5:23pm

Sorry I dodn't give you all the info on this. We did confirm (and created a new) account and checked the db owner addition to the SQL DB files.

Can I just hire you to fix this for me?

Randy

]]> Fri, 11 Jan 2008 17:23:32 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11518&title=quarantine-db-not-active#11518 <![CDATA[Quarantine DB not active : Randy,In the username/password...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11514&title=quarantine-db-not-active#11514 Author: LogSat
Subject: 6335
Posted: 11 January 2008 at 5:02pm

Randy,

In the username/password fields, are you sure you specified a valid SQL account (not a Windows account) that has "db owner" access to the SpamFilter database? Please also ensure the "Save password" box is checked.
]]> Fri, 11 Jan 2008 17:02:41 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11514&title=quarantine-db-not-active#11514 <![CDATA[Quarantine DB not active : Okay, back to the resolution search. I...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11513&title=quarantine-db-not-active#11513 Author: rdemeyer
Subject: 6335
Posted: 11 January 2008 at 4:51pm

Okay, back to the resolution search.

I created new database and tested the connection in the UDL Window. Tested okay. However in SPam Filter, when I check the connection in the "settings" it still gives the same error.

Error Connecting to database!-

[DBNETLIB][ConnectionOpen{Connect{}.]SQL Server

does not exist or access denied

Any new ideas?

Thanks

Randy

]]> Fri, 11 Jan 2008 16:51:12 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11513&title=quarantine-db-not-active#11513 <![CDATA[Quarantine DB not active : Randy,Please see below a section...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11448&title=quarantine-db-not-active#11448 Author: LogSat
Subject: 6335
Posted: 07 January 2008 at 7:24pm

Randy,

Please see below a section of SpamFilter's user manual that talks how to configure an MS SQL database using UDL files (our recommended approach).

You can download the documentation (that includes the screenshots missing from the post below) from:
www.logsat.com/spamfilter/pub/SpamFilterDocs.zip

The steps to configure SpamFilter ISP to use a Microsoft SQL Server database are:

1.    Install Microsoft SQL Server on a server (it can be installed on the same server running SpamFilter).
2.    Create an empty database in SQL Server. The samples below assume this database to be named “spamfilter”, but you can use any other naming convention
3.    In SQL Server, create a new SQL user and assign it dbo privileges for the “spamfilter” database. After the necessary tables have been created, the privileges can be reduced to allow this user only read/write data.
4.    Configure the database connection in SpamFilter to point to the above database. The simplest way to proceed is to use a UDL file (Microsoft's Universal DataLink) to define the connection to the SQL server. In the SpamFilter\database directory you'll find several .UDL files for each database platform. Please double-click on the one for SQL Server, SpamFilterMSSQL.udl. The correct OLE DB Provider should already be selected in the "Provider" tab. Under the "Connection" tab enter the name of your SQL server, and provide the username/password just created. Ensure you check the “Allow saving password” box so the credentials are saved in the UDL file. Please see the screenshot in Figure 13 for sample settings. Click on "Test Connection" to ensure the UDL file works.

Figure 13
5.    In SpamFilter, under the "Settings - Quarantine DB" tab, click on the "..." ellipse button to select a Connection String. In the box that follows, select "Use Data Link File" and select the SpamFilterMSSQL.udl you customized before. See screenshot in Figure 14 for sample settings.
6.    Use the 1-2-3 step wizard in SpamFilter's Quarantine DB tab to create the necessary tables in SpamFilter. On step 3, ensure to click on the “Save & Activate Conn String” button.
7.    Click on the “Save Settings” button.

Figure 14

]]> Mon, 07 Jan 2008 19:24:27 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11448&title=quarantine-db-not-active#11448 <![CDATA[Quarantine DB not active : I would go to ODBC adminon the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11442&title=quarantine-db-not-active#11442 Author: WebGuyz
Subject: 6335
Posted: 07 January 2008 at 6:50pm

I would go to ODBC admin on the SF box and try to establish a test connection to your SQL server. This will tell you if your having a connection issue or SF issue. You should be able to click on test connection and verify that the database part is all OK (or not)

]]> Mon, 07 Jan 2008 18:50:08 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11442&title=quarantine-db-not-active#11442 <![CDATA[Quarantine DB not active : The Microsoft SQL Database is...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11440&title=quarantine-db-not-active#11440 Author: rdemeyer
Subject: 6335
Posted: 07 January 2008 at 5:26pm

The Microsoft SQL Database is running on a different server. That Server is running fine and has several other active SQL applications that are not experiencing any errors.

I am not a expert on SQL databases. so I am not sure if there is a way to determine if the DB is not working correctly on the server. But I AM certain that the entire SQL application is working, as we have four other programs using it.

Thanks

Randy

]]> Mon, 07 Jan 2008 17:26:06 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11440&title=quarantine-db-not-active#11440 <![CDATA[Quarantine DB not active : Is the MySQL db on the same server?...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11435&title=quarantine-db-not-active#11435 Author: WebGuyz
Subject: 6335
Posted: 07 January 2008 at 3:33pm

Is the MySQL db on the same server? Can you access MySQL db via some admin tool to make sure its up and operational?]]> Mon, 07 Jan 2008 15:33:03 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11435&title=quarantine-db-not-active#11435 <![CDATA[Quarantine DB not active : I just notice today while trying...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11433&title=quarantine-db-not-active#11433 Author: rdemeyer
Subject: 6335
Posted: 07 January 2008 at 2:26pm

I just notice today while trying to fetch a message in quarantine that SPam Filter isn't connecting to my MS SQL Database. I stopped the applicationa dn restarted it, tested the connection to the SQL server and get an error that he "server doesn't exist of access was denied.

We haven't changed anything on either server (that I am aware of), what else might be causing the problem.

MS SQL 2000

Spam Filter 3.0.1.558

Both running on Dell Poweredge servers and Windows 2003 Server. We don't seem to be having problems with any other of our SQL fed applications.

Thanks

Randy

]]> Mon, 07 Jan 2008 14:26:06 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6335&PID=11433&title=quarantine-db-not-active#11433