How to Move the SQL Database for Dell Security Management Server to a Different SQL Server

Affected Products:

• Dell Security Management Server
• Dell Data Protection | Enterprise Edition Server

Affected Versions:

• v8.0.X and Later

Click the appropriate Dell Security Management Server version. For versioning information, reference How to Identify the Dell Data Security Server Version.

v8.0.0 and Later

1. Stop all [Product] services.
   Note:

   • [Product] =
     • v8.15 and later = Dell
     • v8.14.1 and earlier = Dell Data Protection
   • For more information, reference How to Stop and Start Services in Dell Security Management Server.
2. From the existing SQL Server, create a full SQL database backup.
   Note: For more information, reference Create a Full Database Backup (SQL Server) .
3. From the new SQL Server, restore the SQL database.
   Note: For more information, reference Restore a Database to a New Location (SQL Server) .
4. Confirm that all expected access rights are applied to the SQL Server and database.
   Note: For more information, reference How to Configure SQL for Dell Security Management Server.
5. From the Dell Security Management Server, go to %ENV:SYSTEMDRIVE%\Program Files\Dell\Enterprise Edition\Server Configuration Tool\Credant.Configuration.exe.
   
   • Optionally, search for Server Configuration Tool within the Start Menu, or it can be manually found under the Dell folder, titled Run Server Configuration Tool.
     
6. Click the Database tab.
   
7. From the Database tab:
   1. Populate the new SQL Server Name.
   2. Populate the SQL Server Port.
   3. Populate the SQL Database name.
   4. Select a method of Authentication.
   5. If SQL Authentication is chosen:
      1. Populate the User Name.
      2. Populate the User Name Password.
      3. Go to step 8.
   6. If Windows Authentication is chosen, go to step 8.
      
      Note:

      • Server Name gets populated by a fully qualified domain name (FQDN) or IP address.
      • If an instance is in use, it may be populated beginning with a \ following the Server Name.
      • If the Server Port is left blank, it defaults to 1433, or it attempts to communicate to the SQL Server Browser (if available and enabled), which can define a custom or dynamic SQL port.
      • If Windows authentication is selected, the active Windows account is used to connect to the Dell Data Protection database.
      • The examples used for Server Name, Server Port, Database, Authentication, User Name, and Password may differ in your environment.
8. Select Configuration and then click Save.
   
9. Click Yes.
   
10. Select the Actions menu and then click Test Database Configuration.
    
11. Click Next.
    
12. If using Windows Authentication, optionally:
    1. Check Use different Windows account credentials.
    2. Populate User Name.
    3. Populate Password.
    4. Populate Domain.
    5. Click Next.
       If using SQL Authentication, click Next and then go to step 13.
       
13. Test Connection Settings must show Passed to proceed. If it does not, return to step 7 or use different Windows account credentials (Step 12). Click Finish.
    
14. Select the Configuration menu and then click Save.
    
15. Click Yes.
    
16. Select the Configuration menu and then click Exit.
    
17. Start all [Product] services.
    Note:

    • [Product] =
      • v8.15 and later = Dell
      • v8.14.1 and earlier = Dell Data Protection
    • For more information, reference How to Stop and Start Services in Dell Security Management Server.