Configuring SQL Server for CaseMap Server

Before you install the CaseMap Server, you need to create an admin database and login account in Microsoft SQL Server.

Any time you uninstall/reinstall CaseMap Server, you will need to create a new admin database and login accounts in SQL Server Management Studio.

1.	Open Microsoft SQL Server.

2.	Connect to the database engine using a system administrator account on the server that will contain the CaseMap Server admin database.

3.	In Object Explorer, right-click on the Databases folder and click New Database.

4.	In the New Database dialog box, type in the name of the admin database in the Database Name field, then click OK.

5.	In the Object Explorer pane, expand the Security folder, and then expand the Logins folder.

6.	Right-click on Logins folder and click New Login.

7.	In the Login - New dialog box, type in the login name in the Login name field.

8.	Select the authentication type you want to use: Windows or SQL.

If you choose SQL, then type in a password and confirm it.

If you choose Windows Authentication, the login name must be the same account used for Anonymous Authentication by the CaseMap Server.

9.	In the Default database field, select the admin database you created.

10.	Click OK to continue.

You are now ready to install CaseMap Server.

Help url: /Casemapsuitesupport/cm/welcome.htm?ac_sql_configuring.htm

Configuring SQL Server for CaseMap Server						AC_sql_configuring Dear Answer Center Staff,
Configuring SQL Server for CaseMap Server