Registering SQL Servers
Contents
Once a SQL Server is registered in the CaseMap Admin Console, it is ready to have cases associated with it. Each SQL Server name should be unique and non-case sensitive.
During the server registration process, the Administrative Credentials and Desktop Application Credentials areas require a SQL Server Authentication login account. The SQL Server login account configured for Administrative Credentials should be granted the database owner (dbowner) and database creator (dbcreator) roles. The database owner role is required to successfully perform internal application operations like changing isolation levels and enabling single user mode. The database creator role is required to create new cases directly in the CaseMap Admin Console.
|
If the administrator only wants to register servers (and not create SQL cases) in the CaseMap Admin Console, the database creator role is not needed for that user. |
 |