LogSat Software

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic


   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?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jerbo128 Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 06 March 2006 Status: Offline Points: 178	Post Options Post Reply Quote jerbo128 Report Post Thanks(0) Quote Reply Topic: MS SQL with .639 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?

LogSat Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104	Post Options Post Reply Quote LogSat Report Post Thanks(0) Quote Reply 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 LogSat Software Spam Filter ISP

LogSat Software

Site Navigation[Skip]

Spam Filter ISP Support Forum

MS SQL with .639