This walkthrough assumes that 2 Windows Groups have already been created on Active Directory, or the local SQL Server. In this example the two groups are called MiAdmins and MiPharmacists. Each of these groups should be populated with the windows users who are permitted to use each of the MiDatabank applications - MiAdmins should be populated with those people who will be using the MiDatabank Adminstrator application, and MiPharmacists is for people who will be using the MiDatabank Enquiry Manager application.

1. Open Microsoft SQL Server Management Studio

2. Choose File>Open>File...

3. Open the sql file contained on the CDROM

the sql file is displayed in the right hand panel:-

4. Click the Execute button in the toolbar to run the sql file. The 'Executing query' message appears:-

After a minute or so the execution completes:-

Next, click on the left hand panel and press F5 to refresh the listing of databases. The database called mi should now appear in the listing.

5. The next job is to configure the windows users who are allowed to access the mi database. Using the listing in the left hand panel, expand the Security folder to reveal the Logins folder:-

Next, right-click on the Logins folder and choose 'New Login' from the pop-up menu. This displays the following dialog box:-

6. Enter the MiAdmins group as the Login name, and change the default database to mi. In the example shown below, the MiAdmins group has previously been created on the Active Directory called MAINDOMAIN:-

Next, click on the 'User Mapping' node in the list on the left-hand side, do the following:-

•  check the checkbox called mi in the top list on the right-hand side
•  check the checkbox for MiAdministrator in the bottom list on the right-hand side
•  click the OK button

Database access for users of the MiDatabank Administrator application is now complete

7. Right-click on the Logins folder and choose 'New Login' from the pop-up menu. Enter the MiPharmacists group as the Login name, and change the default database to mi. In the example shown below, the MiPharmacists group has previously been created on the Active Directory called MAINDOMAIN:-

Next, click on the 'User Mapping' node in the list on the left-hand side, do the following:-

•  check the checkbox called mi in the top list on the right-hand side
•  check the checkbox for MiPharmacist in the bottom list on the right-hand side
•  click the OK button

The installation and configuration of the mi database is now complete.

Please note that regular backups of the database should be taken. For further information regarding backups please see the backup documention in the Help tab, or click here.