Skip to main content
  • 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

How to Configure SQL for Dell Security Management Server

Resumen: Learn to configure a SQL server for use with Dell Security Management Server (formerly Dell Data Protection Enterprise Edition) with these instructions.

Este artículo se aplica a: Este artículo no se aplica a: Este artículo no está vinculado a ningún producto específico. En este artículo no se identifican todas las versiones de los productos.

Instrucciones

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

Click SQL Server 2012 to SQL Server 2019 or SQL Server 2005 to SQL Server 2008 R2 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 2012 to SQL Server 2019

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.

  1. Right-click the Windows start menu and then click Run.
    Run
  2. In the Run UI, type ssms.exe and then press OK.
    Run UI
  3. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate Server name.
    3. Select the Authentication method.
    4. If using SQL Server Authentication, populate sysadmin credentials.
    5. Click Connect.
    Connect to Server menu
    Note:
    • Server Name = Fully qualified domain name (FQDN) of the database
    • If a SQL Instance is used, \InstanceName must follow Server Name.
      • InstanceName = The name of the database instance in your environment
    • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  4. Expand Security and then expand Logins.
    Logins
  5. Right-click the user account and click Properties.
    Properties
  6. From the Login Properties window:
    1. Click Server Roles.
    2. Select the sysadmin role.
    3. Click OK.
    Login Properties

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

  1. Right-click the Windows Start menu and then click Run.
    Run
  2. In the Run UI, type ssms.exe and then press OK.
    Run UI
  3. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate 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 = The name of the database instance in your environment
    • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  4. Go to Databases\TestDB\Security\Users.
    Users
    Note: The example, TestDB, will differ from the database name in your environment.
  5. Right-click the user's name and select Properties.
    Properties
  6. From the Database User window:
    1. Click Owned Schemas and then select db_owner.
    2. Click OK.
    Owned Schemas
  7. From the Database User window:
    1. Click Membership and then select db_owner.
    2. Click OK.
    Membership

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

Note: Dell Security Management Server v8.5.1 and earlier requires the database creation before installation.
  1. Right-click the Windows Start menu and then click Run.
    Run
  2. In the Run UI, type ssms.exe and then press OK.
    Run UI
  3. 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 = The name of the database instance in your environment
    • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  4. Right-click Databases and then click New Database.
    New Database
  5. 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.

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

Note: The sysadmin server role is required to change Server authentication settings.
  1. Right-click the Windows start menu and then click Run.
    Run
  2. In the Run UI, type ssms.exe and then press OK.
    Run UI
  3. 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 = The name of the database instance in your environment
    • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  4. Right-click the SQL Instance and then select Properties.
    Properties
  5. From the Server Properties window:
    1. Click Security.
    2. Select SQL Server and Windows Authentication mode.
    3. Click OK.
    Server Properties
  6. Click OK.
    Restart notification
  7. 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.

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

  1. Double-click the SQL install media.
    SQL install media
  2. Double-click setup.exe.
    Setup
    Note: Administrative rights are required to run setup.exe.
  3. Click Installation.
    Installation
  4. 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
  5. Click OK.
    Setup Support Rules
  6. Optionally, select Include SQL Server Updates and then click Next.
    Product Updates
  7. Click Next.
    Setup Support Rules
  8. 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.
  9. Select Full-Text and Semantic Extractions for Search and then click Next.
    Feature Selection
  10. Click Next.
    Installation Rules
  11. Click Next.
    Disk Space Requirements
  12. Click Next.
    Server Configuration
  13. Optionally, select Send Windows and SQL Server Error Reports to Microsoft or your corporate report server and then click Next.
    Error Reporting
  14. Click Install.
    Ready to Install
  15. Upon installation, click Close to exit the UI.
    Complete

SQL Server 2005 to SQL Server 2008 R2

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.
  1. Click the Windows Start menu and then click Run.
    Run
  2. In the Run UI, type ssms.exe and then press OK.
    Run UI
  3. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate 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 = The name of the database instance in your environment
    • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  4. Expand Security and then expand Logins.
    Logins
  5. Right-click the user account and click Properties.
    Properties
  6. From the Login Properties window:
    1. Click Server Roles.
    2. Select the sysadmin role.
    3. Click OK.
    Login Properties

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

  1. Click the Windows Start menu and then click Run.
    Run
  2. In the Run UI, type ssms.exe and then press OK.
    Run UI
  3. From the Connect to Server menu:
    1. Select Database Engine as the server type.
    2. Populate 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 = The name of the database instance in your environment
    • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  4. Go to Databases\TestDB\Security\Users.
    Users
    Note: The example, TestDB, will differ from the database name in your environment.
  5. Right-click the user's name and select Properties.
    Properties
  6. 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

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.
  1. Click the Windows Start menu and then click Run.
    Run
  2. In the Run UI, type ssms.exe and then press OK.
    Run UI
  3. 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 = The name of the database instance in your environment
    • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  4. Right-click Databases and then click New Database.
    New Database
  5. 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.

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

Note: The sysadmin server role is required to change Server authentication settings.
  1. Click the Windows Start menu and then click Run.
    Run
  2. In the Run UI, type ssms.exe and then press OK.
    Run UI
  3. 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 = The name of the database instance in your environment
    • If using Windows Authentication, smss.exe must be run as an account with sysadmin credentials.
  4. Right-click the SQL Instance and then select Properties.
    Properties
  5. From the Server Properties window:
    1. Click Security.
    2. Select SQL Server and Windows Authentication mode.
    3. Click OK.
    Server Properties
  6. Click OK.
    Restart notification
  7. 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.

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

  1. Double-click the SQL install media.
    SQL install media
  2. Double-click setup.exe.
    Setup
    Note: Administrative rights are required to run setup.exe.
  3. Click Installation.
    Installation
  4. 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
  5. Click OK.
    Setup Support Rules
  6. Click Install.
    Setup Support Files
  7. Click Next.
    Setup Support Rules
  8. 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.
  9. Select Full-Text Search and then click Next.
    Feature Selection
  10. Click Next.
    Installation Rules
  11. Click Next.
    Disk Space Requirements
  12. Click Next.
    Server Configuration
  13. Optionally, select Send Windows and SQL Server Error Reports to Microsoft or your corporate report server and then click Next.
    Error Reporting
  14. Click Next.
    Installation Configuration Rules
  15. Click Install.
    Ready to Install
  16. 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.

Información adicional

 

Vídeos

 

Productos afectados

Dell Encryption
Propiedades del artículo
Número de artículo: 000124909
Tipo de artículo: How To
Última modificación: 16 sept 2024
Versión:  10
Encuentra las respuestas que necesitas con la ayuda de otros usuarios de Dell
Servicios de asistencia
Comprueba si tu dispositivo está cubierto por los servicios de asistencia.