Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Quarantine db is not active at startup
  FAQ FAQ  Forum Search   Register Register  Login Login

Quarantine db is not active at startup

 Post Reply Post Reply
Author
hartsockt View Drop Down
Newbie
Newbie


Joined: 31 May 2009
Location: Arizona
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote hartsockt Quote  Post ReplyReply Direct Link To This Post Topic: Quarantine db is not active at startup
    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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.