Creating a database in Microsoft® SQL Server 2000

Creating a database in Microsoft® SQL Server 2000

To create a MailDetective DB on Microsoft® SQL Server 2000, start the Query Analyzer utility from the SQL server bundle. When you have connected to the server, choose Load SQL Script:



You can find the SQL script to create a DB in MS SQL in the folder <MD>\dbscripts\mssql, with <MD> being the folder where MailDetective is installed. By default, the DB you create gets the name MD_EXCHANGE. If you want to name it differently, you must change all of the lines with "MD_EXCHANGE" to another legitimate DB name. When you have the script opened (and if necessary, edited), select Query > Execute to create a database. The default character table and folder from the server settings will be used for its creation.

Once this is done, you`ll need to set the DB parameters in MailDetective. Start MailDetective and choose Database > Program settings from the page Database > ADO access:



Press Build button:



select Microsoft OLD DB Provider  for SQL Server and press Next>>:



You need to enter the server name and select authorization method, then you should select database name on the server(MD_EXCHANGE if you have not changed it).

After that, choose ADO access on the page Database and click OK; then restart MailDetective. When you`ve completed this operation, choose Database > Connect to connect to the database.