Using an SQL server as a quarantine index
iQ.Suite quarantines comprise blocked emails and an index database. Standard practice is to use a local MDB file. Very big quarantines may reach the maximum MDB capacity of two gigabytes, making it necessary to deploy an SQL server. Read about the steps you need to take here.
Step by Step:
- iQ.Suite quarantines comprise blocked emails and an index database. Standard practice is to use a local MDB file. Very big quarantines may reach the maximum MDB capacity of two gigabytes, making it necessary to deploy an SQL server. Read about the steps you need to take here.
- For the data link, you will also need a SQL login. The solution does not support Windows user authentication.
- This login is assigned read and write permissions for the database you create.
- You need to create the necessary tables in the database. To do this, use the "Quarantine.sql" script, which you will find in the folder iQ.SuiteSupport. Execute the script in the new database context.
- Your next step is to configure the database connection in iQ.Suite. The database connections are located in the basic configuration. The "Initial Catalog" (name of database) and "Data Source" (name of SQL server) are stored in the connection string. Example: Provider=SQLOLEDB;Initial Catalog=Anti-Spam High;Data Source=MorpheusSQLExpress;User ID=[ADOUser];Password=[ADOPwd]
- Enter the SQL login ID and password in the appropriate fields.
- Finally, create a new quarantine and specify the database connection. N.B.: You can only do this when you initially create the quarantine. It cannot be changed later on.
- The SQL database is then used to provide index information when data is written to this quarantine.
