How to Configure SQL for Dell Security Management Server

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 the Authentication method.
   4. If using SQL Server Authentication, populate sysadmin credentials.
   5. Click Connect.
   
   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.
   
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.

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 the Authentication method.
   4. If using SQL Server Authentication, populate sysadmin credentials.
   5. Click Connect.
   
   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.
   
   Note: The example, TestDB, will differ from the database name in your environment.
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, the Dell Security Management Server installer can create it during installation.

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

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.
   
   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.
   
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.
   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.
   
2. Double-click setup.exe.
   
   Note: Administrative rights are required to run 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.
   
   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.
   
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.
    

1. 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 the Authentication method.
   4. If using SQL Server Authentication, populate sysadmin credentials.
   5. Click Connect.
   
   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.
   
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.

1. 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 the Authentication method.
   4. If using SQL Server Authentication, populate sysadmin credentials.
   5. Click Connect.
   
   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.
   
   Note: The example, TestDB, will differ from the database name in your environment.
5. Right-click the user's name and select 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.
   

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

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

1. 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.
   
   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.
   
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.
   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.
   
2. Double-click setup.exe.
   
   Note: Administrative rights are required to run setup.exe.
3. Click Installation.
   
4. Click New SQL Server stand-alone installation or add features to an existing installation.
   
5. Click OK.
   
6. Click Install.
   
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.
   
   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.
   
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 Next.
    
15. Click Install.
    
16. Upon installation, click Close to exit the UI.