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.