Print Page | Close Window

MS SQL with .639

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5980
Printed Date: 14 March 2025 at 7:38pm


Topic: MS SQL with .639
Posted By: jerbo128
Subject: MS SQL with .639
Date Posted: 17 February 2007 at 11:39am

I am trying to setup MSSQL with the beta .639.  I have ran the SQL script MSSWL_with_user_perms.  The database is created.  I also added a user "spamfilteruser" to SQL and gave it permissions to the new database.  I created the connection string, connected and then choose "Create / Check database tables"  The output is:
================
please wait...
Found tblQuarantine
Found tblMsgs
Found tblRejectCodes
Found tblLogins
Found tblServers
Retrieved ServerID from tblServers: 1

ERROR - Some fields are missing from the tables!
Please proceed to Step 2-b to add missing fields
Done.
+++++++++++++++++++++++++
When I move to step 2B, there are no update scripts from which to choose. 

I have been through this entire process 10-12 times, deleting the database and trying the different SQL scripts that are included in the database folder.  I have even tried moving from standard to enterprise mode and going that route.

Anyone successful in using MSSQL?  Any idea's that might help me?


Replies:
Posted By: LogSat
Date Posted: 17 February 2007 at 4:17pm
We've been able to reproduce the problem. While we look into a solution (there seems to be an error within the SQL script), you should be able to (1) create a blank, empty database in MSSQL using the MS Enterprise Manager, (2) in SpamFilter, go thru the 1-2-3 step database wizard. The wizard will take care of creating the tables for you.

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Print Page | Close Window