Spam Filter ISP Forums : Quarantine db is not active at startup https://www.logsat.com/spamfilter/forums/ Mon, 09 Mar 2026 19:57:16 +0000 Wed, 21 Apr 2010 23:07:35 +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=6824 <![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 is not active at startup : Tom,From your connection string,...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6824&PID=13568&title=quarantine-db-is-not-active-at-startup#13568 Author: LogSat
Subject: 6824
Posted: 21 April 2010 at 11:07pm

Tom,

From your connection string, we see you're connecting to the SQL server using integrated security for authentication. If you're running SpamFilter as a service, it will usually be running as SYSTEM, and the SYSTEM account (which will be the one being picked up by integrated security authentication) most likely won't have access to the SpamFilter database.

Can you please try specifying a SQL username/password in the connection, or even better, use a UDL file to specify the connection? A sample UDL files for a SQL Server connection is included in the \SpamFilter\databases directory. Simply double-click that file to change the connections settings to suit your environment.
]]> Wed, 21 Apr 2010 23:07:35 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6824&PID=13568&title=quarantine-db-is-not-active-at-startup#13568 <![CDATA[Quarantine db is not active at startup : For some reason, every time I...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6824&PID=13555&title=quarantine-db-is-not-active-at-startup#13555 Author: hartsockt
Subject: 6824
Posted: 16 April 2010 at 7:50am

For some reason, every time I restart the server running spam filter isp, I have to manually click the 'Save & Activate Conn String'.  Until I do that, the quarantine database remains inactive.  Is there a setting that can make the connection become active automatically at start up without user intervention?

My connection string is as follows:
Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SpamFilterISP

Thank you,

Tom
]]> Fri, 16 Apr 2010 07:50:56 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6824&PID=13555&title=quarantine-db-is-not-active-at-startup#13555