Configuring a Microsoft SQL Server for MAP

When installing the Media Access Proxy (MAP) software for use with Microsoft SQL Server 2005 Enterprise Edition SP2 or SQL Server 2008, you need to configure the Microsoft SQL Server database.

Before you begin

Make sure that you have created the install image as described in the Creating the MAP install image on your application server topic.

About this task

When installing MAP, be aware of the following issues:

Use the SQL Server Management Studio when performing this installation procedure.
For MAP to work with the Microsoft SQL Server 2005 Enterprise Edition SP2 or SQL Server 2008 Database, the following JDBC drivers can be used:
- NetDirect JDBC driver, which can be downloaded from the jnetDirect website
- Microsoft SQL Server 2005 or 2008 JDBC driver, which can be downloaded from the Microsoft website

Important: Do not create any tables manually within the MAP database.

Perform the following steps to create and configure the MAP database.

Procedure

Create the MAP database. Run the following command sequence:
Note: When creating this database, choose Case Insensitive.
```
use master;
go
create database MAPDB collate SQL_Latin1_General_CP1_CI_AS;
```
Create the login account for the database. Run the following command sequence:
```
use master;
go
CREATE LOGIN MAPDBUSR WITH PASSWORD = 'password'; 
```
where password is any valid database password.

Grant access to the database. Run the following command sequence:

use MAPDB;
exec sp_grantdbaccess @loginame = 'MAPDBUSR';
exec sp_addrolemember @rolename = 'db_owner' , @membername = 'MAPDBUSR';
go

What to do next

After the database is configured, you can install the MAP software.