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.
    3. Right-click
      Databases
      and then select
      New Database
      .
  2. Configure the database settings.
    The database owner that you specify must already exist as a local or domain administrator.
    1. Enter the
      Database name
      .
    2. Select the database
      Owner
      :
      1. Click the ellipsis ( ) 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
      Security
      Users
      .
    2. Double-click
      dbo
      .
    3. Select the
      Owned Schemas
      page and then select
      db_owner
      .
    4. Select the
      Membership
      page and then select
      db_owner
      .
    5. Click
      OK
      .

Recommended For You