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

To assign sysadmin role:

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

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

3. 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.

4. Expand Security and then expand Logins.

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

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

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.

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

3. 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.

4. Go to Databases\TestDB\Security\Users.

5. Right-click the user's name and select Properties.

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

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

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.

To create the database:

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

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

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.

4. Right-click Databases and then click 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.

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

To enable SQL Server and Windows Authentication:

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

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

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.

4. Right-click the SQL Instance and then select Properties.

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

6. Click OK.

7. Restart the server with SQL Server installed.

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.

2. Double-click setup.exe.

3. Click Installation.

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

5. Click OK.

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

7. Click Next.

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.

9. Select Full-Text and Semantic Extractions for Search and then click Next.

10. Click Next.

11. Click Next.

12. Click Next.

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

14. Click Install.

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