Configure the MS-SQL Server Database

The Endpoint Security Manager requires a database that is managed over the SQL Server platform (for supported SQL Server versions, see Database Software Requirements ). The Endpoint Security Manager uses the database to store administrative information, security policy rules, information about security events, and other information.
Before installing the Endpoint Security Manager, configure the SQL database with the required permissions. When using Windows Authentication as the user authentication method, the owner must have rights to Log on as a service and be a local administrator on the ESM Server.
The following procedure is recommended as a best practice for creating and configuring the MS-SQL Server database.
  1. Create a new database.
    1. Select SQL Server Management Studio from the Start menu.
    2. Click Connect to open Microsoft SQL Server Management Studio.
      my-sql-connect.png
    3. Right-click Databases and then select New Database.
      my-sql-new-database.png
  2. Configure the database settings.
    The database owner that you specify must already exist as a local or domain administrator.
    my-sql-config-database.png
    1. Enter the Database name.
    2. Select the database Owner:
      1. Click the ellipsis ( sql-check-names.png ) button.
      2. Enter the object name in the format [domain\user] or Browse to an object name.
      3. Select Check Names to validate the database owner.
    3. Click OK and then click OK again.
  3. Verify the database owner privileges.
    1. Expand the database you created and then select SecurityUsers.
    2. Double-click dbo.
      ms-sql-db-security-users.png
    3. Select the Owned Schemas page and then select db_owner.
    4. Select the Membership page and then select db_owner.
    5. Click OK.

Related Documentation