Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

Article Number: 000124909

How to Configure SQL for Dell Security Management Server / Dell Data Protection Enterprise Edition Server

Summary: A SQL server may be configured for use with Dell Security Management Server by following these instructions.

This article may have been automatically translated. If you have any feedback regarding its quality, please let us know using the form at the bottom of this page.

Article Content

Symptoms

This article covers the configuration of the SQL server when used with Dell Security Management Server (formerly Dell Data Protection | Enterprise Edition).

Affected Products:

Dell Security Management Server
Dell Data Protection | Enterprise Edition

Cause

Not applicable.

Resolution

Click the appropriate SQL server version for required Dell Security Management Server configurations.

Note: Dell Security Management Server does not support any version of SQL Server Express in a production environment.

SQL Server may require configuration to:

  • Assign sysadmin role.
  • Assign database role.
  • Create the SQL database.
  • Enable mixed authentication.
  • Add full-text search capabilities.

Click the appropriate process for more information.

Assign Sysadmin Role

To assign sysadmin role:

  1. Right-click the Windows start menu and then click Run.

Run

  1. In the Run UI, type ssms.exe and then press OK.

Run UI

  1. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate Server name.
    3. Select Authentication method.
    4. If using SQL Server Authentication, populate sysadmin credentials.
    5. Click Connect.

SLN307771_en_US__4ddpkm1265c(1)

Note:
  • Server Name = fully qualified domain name (FQDN) of the database
  • If a SQL Instance is used, \InstanceName must follow Server Name.
    • InstanceName represents the name of the database instance in your environment.
  • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  1. Expand Security and then expand Logins.

Logins

  1. Right-click the user account and click Properties.

Properties

  1. From the Login Properties window:
    1. Click Server Roles.
    2. Select the sysadmin role.
    3. Click OK.

Login Properties

Assign Database Role

The account used to manage SQL access for Dell Security Management Server requires the db_owner role be assigned.

To assign the database role:

  1. Right-click the Windows start menu and then click Run.

Run

  1. In the Run UI, type ssms.exe and then press OK.

Run UI

  1. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate Server name.
    3. Select Authentication method.
    4. If using SQL Server Authentication, populate sysadmin credentials.
    5. Click Connect.

Connect to Server

Note:
  • Server Name = fully qualified domain name (FQDN) of the database
  • If a SQL Instance is used, \InstanceName must follow Server Name.
    • InstanceName represents the name of the database instance in your environment.
  • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  1. Go to Databases\TestDB\Security\Users.

Users

Note: The example, TestDB, will differ from the database name in your environment.
  1. Right-click the user's name and select Properties.

Properties

  1. From the Database User window:
    1. Click Owned Schemas and then select db_owner.
    2. Click OK.

Owned Schemas

  1. From the Database User window:
    1. Click Membership and then select db_owner.
    2. Click OK.

Membership

Create the SQL Database

Dell Security Management Server allows a SQL database to be created before installation of the server software. Alternatively, it can be created by the Dell Security Management Server installer during installation.

Note: Dell Security Management Server v8.5.1 and earlier requires the database creation before installation.

To create the database:

  1. Right-click the Windows start menu and then click Run.

Run

  1. In the Run UI, type ssms.exe and then press OK.

Run UI

  1. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate the Server name.
    3. Select the Authentication method.
    4. If using SQL Server Authentication, populate sysadmin credentials.
    5. Click Connect.

Connect to Server

Note:
  • Server Name = fully qualified domain name (FQDN) of the database
  • If a SQL Instance is used, \InstanceName must follow Server Name.
    • InstanceName represents the name of the database instance in your environment.
  • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  1. Right-click Databases and then click New Database.

New Database

  1. From the New Database menu:
    1. Populate a Database name.
    2. Populate Owner with either a Windows login or SQL Server login account.
    3. Click OK.

New Database menu

Note: The account assigned as Owner is populated as the service account during the Dell Security Management Server install when using Windows Authentication to the SQL Server.
Enable Mixed Authentication

Mixed authentication options must be enabled in SQL Server to use both methods of authentication from the Dell Security Management Server.

Note: Sysadmin server role is required to make changes to Server authentication settings.

To enable SQL Server and Windows Authentication:

  1. Right-click the Windows start menu and then click Run.

Run

  1. In the Run UI, type ssms.exe and then press OK.

Run UI

  1. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate Server name.
    3. Select Windows Authentication.
    4. Click Connect.

Connect to Server

Note:
  • Server Name = fully qualified domain name (FQDN) of the database
  • If a SQL Instance is used, \InstanceName must follow Server Name.
    • InstanceName represents the name of the database instance in your environment.
  • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  1. Right-click the SQL Instance and then select Properties.

Properties

  1. From the Server Properties window:
    1. Click Security.
    2. Select SQL Server and Windows Authentication mode.
    3. Click OK.

Server Properties

  1. Click OK.

Restart notification

  1. Restart the server with SQL Server installed.
Note: The server may be restarted once there is downtime; however, the changes do not take effect until the server is restarted.
Add Full-Text Search Capabilities

Full-text search capabilities are required when installing Dell Security Management Server v9.9.2 and later.

To add the feature running the SQL Setup:

  1. Double-click the SQL install media.

SQL install media

  1. Double-click setup.exe.

Setup

Note: Administrative rights are required to run setup.exe.
  1. Click Installation.

Installation

  1. Click New SQL Server stand-alone installation or add features to an existing installation.

New SQL Server stand-alone installation or add features to an existing installation

  1. Click OK.

Setup Support Rules

  1. Optionally, select Include SQL Server Updates and then click Next.

Product Updates

  1. Click Next.

Setup Support Rules

  1. From the Installation Type menu:
    1. Select Add Features to an existing instance of SQL Server.
    2. Select the database Instance Name from the dropdown box.
    3. Click Next.

Installation Type

Note: The product edition of SQL Server will differ from the example image if a different edition of SQL Server is in use.
  1. Select Full-Text and Semantic Extractions for Search and then click Next.

Feature Selection

  1. Click Next.

Installation Rules

  1. Click Next.

Disk Space Requirements

  1. Click Next.

Server Configuration

  1. Optionally, select Send Windows and SQL Server Error Reports to Microsoft or your corporate report server and then click Next.

Error Reporting

  1. Click Install.

Ready to Install

  1. Upon installation, click Close to exit the UI.

Complete

SQL Server may require configuration to:

  • Assign sysadmin role.
  • Assign database role.
  • Create the SQL database.
  • Enable mixed authentication.
  • Add full-text search capabilities.

Click the appropriate process for more information.

Note:
  • Microsoft SQL Server 2005 is no longer supported with Dell Security Management Server v9.2.0 or later.
  • Microsoft SQL Server 2008 is no longer supported with Dell Security Management Server v9.7.0 or later.
  • Microsoft SQL Server 2008 R2 is no longer supported with Dell Security Management Server v10.2.9 or later.
Assign Sysadmin Role

To assign sysadmin role:

  1. Click the Windows start menu and then click Run.

Run

  1. In the Run UI, type ssms.exe and then press OK.

Run UI

  1. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate Server name.
    3. Select Authentication method.
    4. If using SQL Server Authentication, populate sysadmin credentials.
    5. Click Connect.

Connect to Server

Note:
  • Server Name = fully qualified domain name (FQDN) of the database
  • If a SQL Instance is used, \InstanceName must follow Server Name.
    • InstanceName represents the name of the database instance in your environment.
  • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  1. Expand Security and then expand Logins.

Logins

  1. Right-click the user account and click Properties.

Properties

  1. From the Login Properties window:
    1. Click Server Roles.
    2. Select the sysadmin role.
    3. Click OK.

Login Properties

Assign Database Role

The account used to manage SQL access for Dell Security Management Server requires the db_owner role be assigned.

To assign the database role:

  1. Click the Windows start menu and then click Run.

Run

  1. In the Run UI, type ssms.exe and then press OK.

Run UI

  1. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate Server name.
    3. Select Authentication method.
    4. If using SQL Server Authentication, populate sysadmin credentials.
    5. Click Connect.

Connect to Server

Note:
  • Server Name = fully qualified domain name (FQDN) of the database
  • If a SQL Instance is used, \InstanceName must follow Server Name.
    • InstanceName represents the name of the database instance in your environment.
  • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  1. Go to Databases\TestDB\Security\Users.

Users

Note: The example, TestDB, will differ from the database name in your environment.
  1. Right-click the user's name and select Properties.

Properties

  1. From the Database User window:
    1. Click General.
    2. Select db_owner under Owned Schemas.
    3. Select db_owner under Role Members.
    4. Click OK.

Database User

Create the SQL Database

Dell Security Management Server allows for a SQL database to be created before installation of the server software.

Note: Dell Security Management Server v8.0 to v8.5.1 requires the database creation before installation.

To create the database:

  1. Click the Windows start menu and then click Run.

Run

  1. In the Run UI, type ssms.exe and then press OK.

Run UI

  1. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate the Server name.
    3. Select the Authentication method.
    4. If using SQL Server Authentication, populate sysadmin credentials.
    5. Click Connect.

Connect to Server

Note:
  • Server Name = fully qualified domain name (FQDN) of the database
  • If a SQL Instance is used, \InstanceName must follow Server Name.
    • InstanceName represents the name of the database instance in your environment.
  • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  1. Right-click Databases and then click New Database.

New Database

  1. From the New Database menu:
    1. Populate a Database name.
    2. Populate Owner with either a Windows login or SQL Server login account.
    3. Click OK.

New Database menu

Note: The account assigned as Owner is populated as the service account during the Dell Security Management Server install when using Windows Authentication to the SQL Server.
Enable Mixed Authentication

Mixed authentication options must be enabled in SQL Server to use both methods of authentication from the Dell Security Management Server.

Note: Sysadmin server role is required to make changes to Server authentication settings.

To enable SQL Server and Windows Authentication:

  1. Click the Windows start menu and then click Run.

Run

  1. In the Run UI, type ssms.exe and then press OK.

Run UI

  1. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate Server name.
    3. Select Windows Authentication.
    4. Click Connect.

Connect to Server

Note:
  • Server Name = fully qualified domain name (FQDN) of the database
  • If a SQL Instance is used, \InstanceName must follow Server Name.
    • InstanceName represents the name of the database instance in your environment.
  • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  1. Right-click the SQL Instance and then select Properties.

Properties

  1. From the Server Properties window:
    1. Click Security.
    2. Select SQL Server and Windows Authentication mode.
    3. Click OK.

Server Properties

  1. Click OK.

Restart notification

  1. Restart the server with SQL Server installed.
Note: The server may be restarted once there is downtime; however, the changes do not take effect until the server is restarted.
Add Full-Text Search Capabilities

Full-text search capabilities are required when installing Dell Security Management Server v9.9.2 and later.

To add the feature running the SQL Setup:

  1. Double-click the SQL install media.

SQL install media

  1. Double-click setup.exe.

Setup

Note: Administrative rights are required to run setup.exe.
  1. Click Installation.

Installation

  1. Click New SQL Server stand-alone installation or add features to an existing installation.

New SQL Server stand-alone installation or add features to an existing installation

  1. Click OK.

Setup Support Rules

  1. Click Install.

Setup Support Files

  1. Click Next.

Setup Support Rules

  1. From the Installation Type menu:
    1. Select Add Features to an existing instance of SQL Server.
    2. Select the database Instance Name from the dropdown box.
    3. Click Next.

Installation Type

Note: The product edition of SQL Server will differ from the example image if a different edition of SQL Server is in use.
  1. Select Full-Text Search and then click Next.

Feature Selection

  1. Click Next.

Installation Rules

  1. Click Next.

Disk Space Requirements

  1. Click Next.

Server Configuration

  1. Optionally, select Send Windows and SQL Server Error Reports to Microsoft or your corporate report server and then click Next.

Error Reporting

  1. Click Next.

Installation Configuration Rules

  1. Click Install.

Ready to Install

  1. Upon installation, click Close to exit the UI.

Complete

To contact support, reference Dell Data Security International Support Phone Numbers.
Go to TechDirect to generate a technical support request online.
For additional insights and resources, join the Dell Security Community Forum.

 

Additional Information

 

Videos

 

Article Properties

Affected Product

Dell Encryption

Last Published Date

19 Dec 2022

Version

9

Article Type

Solution

Back to Top