Attaching a GFI MailArchiver 3 database

NOTE 1: You can only attach GFI MailArchiver 3 databases based on Microsoft SQL Server. GFI MailArchiver 5 does not support Microsoft Access databases any longer.

NOTE 2: You can only attach a GFI MailArchiver 3 database for browsing and searching. Thus, you cannot select an attached GFI MailArchiver 3 database for further archiving, since GFI MailArchiver 5 treats it as read only.

To attach a GFI MailArchiver 3 database, follow these steps:

1. Load the GFI MailArchiver configuration as shown in the ‘Introduction to the Configuration’ section earlier in this chapter.

2. Click on the GFI MailArchiver > Configuration > Archive Stores node, in the left navigation pane.

3. Click Attach GFI MailArchiver 3 Database, to display the Archive Store Wizard.

Screenshot 60 - Attaching a GFI MailArchiver 3 database

4. In the first page of the wizard, type a name for the archive store in the Archive Store Name box. The name you give the archive store should be descriptive, for example, ‘Jan - Mar 2006’. This makes it easier for you to manage the archive stores and helps the users of your network select the correct archive store to browse and search through.

5. To grant your network users the ability to browse and search through the archived emails, select the Allow users to browse and search this archive store check box.

NOTE: The Do not allow further archiving into this archive store check box is selected by default and cannot be changed, since GFI MailArchiver 5 treats GFI MailArchiver 3 databases as read only.

6. Click Next to continue.

7. Select the Microsoft SQL Server where the GFI MailArchiver 3 database is stored from the Microsoft SQL Server box. If the Microsoft SQL Server you want to use is not detected and listed automatically by the wizard, you can type the IP or machine name of the server hosting the Microsoft SQL Server you want to use.

NOTE: If you want to connect to a Microsoft SQL Server on an alternate port, type the port number in the Microsoft SQL Server box using the following format, ‘SQLServerMachineName, PortNumber’.

Screenshot 61 – Select Microsoft SQL Server and authentication method

8. Select the authentication method you want to use. If you select Windows Authentication, the Wizard will use the credentials of the account displayed in parenthesis next to the option. If you want to use SQL Server authentication, click Microsoft SQL Server Authentication and type the login name and password in the Login Name and Password boxes respectively. Click Next to continue.

NOTE 1: Regardless of which authentication method you choose, ensure that the account used to log on has administrative privileges or is set as the database owner, ‘dbo’, on the database.

NOTE 2: The wizard does not store the credentials specified in this page. The wizard will only use the credentials to connect and verify the schema in the GFI MailArchiver 3 database.

9. Click on the database you want to attach, and then click Next.

Screenshot 62 - Selecting the GFI MailArchiver 3 database

10. The wizard will connect to the selected database and verify the GFI MailArchiver 3 database schema. When the wizard completes, it displays Database verification successful. Click Next to continue.

Screenshot 63 – GFI MailArchiver 3 database schema verified

11. GFI MailArchiver creates two roles, ‘db_marc_archive’ and ‘db_marc_browse’, on the database selected for added security. GFI MailArchiver uses the ‘db_marc_browse’ role for browsing only and requires read only access. GFI MailArchiver uses the ‘db_marc_archive’ role for write access only. You now need to specify the accounts to use for the archiving and browsing roles.

Screenshot 64 - Specifying the Archiving and Search /Browsing accounts

NOTE 1: We recommend using different accounts for archiving and browsing, since it will result in increased security. To do so, leave the Use the same credentials specified for the archiving role check box clear.

NOTE 2: We recommend specifying nonexistent accounts, for both archiving and browsing roles, so that the wizard will create them automatically for you with the correct database roles assigned. To do so, leave the Create the login accounts specified automatically if they do not exist check box selected.

Click Next to create the accounts and continue.

12. The wizard will connect to the database to create the specified accounts and assign the respective role. When the wizard completes it displays User creation successful. Click Next to continue.

Screenshot 65 - Archiving and Search /Browsing accounts created

13. GFI MailArchiver creates a search index, based on the content of the emails currently archived in the GFI MailArchiver 3 database, to speed up user search requests. GFI MailArchiver stores the search index on disk (NTFS). In this page, you need to specify the full path where you want to store the search index for this archive store, either by typing it in the Full path to search index storage location box or else by selecting the folder visually from the list.

Screenshot 66 - Specifying where to store the search index

NOTE: The search index should be stored on a disk with ample free space available, since it can consume a lot of disk space, depending on the size of the GFI MailArchiver 3 database you are attaching.

Click Next to continue.

14. The wizard finish page displays a summary of the settings you configured. Review the settings and click Finish to complete the wizard.

Screenshot 67 - Archive Store Wizard finish page

15. The table in the Archive Stores page lists the attached GFI MailArchiver 3 database as a new archive store. To save the archive store in the configuration, click Save Settings.

Screenshot 68 - GFI MailArchiver 3 database saved in configuration