Assigning SQL permissions on remote SQL Servers - Genetec Mission Control™

Genetec Mission Control™ Deployment Guide

Applies to
Genetec Mission Control™
Last updated
Content type
Guides > Deployment guides
English (United States)
Genetec Mission Control™

You must have the necessary SQL permissions on the remote SQL server with Genetec™ Server services where the Incident Manager role is active.

Before you begin

Install SQL Server Management Studio (SSMS) on your system. You can download an instance from

For information on installing SQL Server on a separate drive, see the Security Center Installation and Upgrade Guide.

What you should know

Security Center offers two modes of user authentication whilst connecting to the SQL server:
Windows Authentication
Configured by default. The SQL server has the same login credentials as the Windows administrator.
SQL Server Authentication
Configure for advanced scenarios. This enables dual authentication because when you configure this option, the default Windows Authentication is also available.


To configure dual authentication:

  1. Open SQL Server Management Studio.
  2. In the Object Explorer pane, right-click the SQL Server instance and select Properties.
    The Server Properties dialog box opens.
  3. In the Select a page pane, click Security.
  4. In the Server authentication section, select SQL Server and Windows Authentication mode and click OK.
    NOTE: For your configuration to take effect, you must restart your SQL Server.
  5. Restart SQL Server:
    1. Open SQL Server Configuration Manager.
    2. In the Sql Server Configuration Manager pane, select SQL Server Services.
    3. Right-click SQL Server (SQLEXPRESS) and click Restart.
    Dual authentication is now configured.
  6. Create a new SQL Server login using SQL Server Authentication:
    1. In the Object Explorer pane, click Security > Logins > New Login.
      The Login- New window opens.
    2. Select SQL Server Authentication.
      Tip: Remember the login credentials for your SQL server. You would require Administrator level access to reset them.
    3. Enter a login name.
    4. Enter a new password.
    5. Clear the Enforce password policy option.
    6. From the Default database list, select IncidentManagement.
    7. In the Select a page pane, select Server Roles.
    8. In the Server Roles section, select one of the following:
      For Security Center versions and later.
      For Security Center versions and earlier.