Quarantine db is not active at startup |
Post Reply 
|
| Author | |
hartsockt 
Newbie 
Joined: 31 May 2009 Location: Arizona Status: Offline Points: 11 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Quarantine db is not active at startupPosted: 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 |
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4106 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.203 seconds.