Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance
iii
Contents
Executive Summary ..................................................................................................... 4
Introduction .............................................................................................................. 4
Advantages of setting up multiple OpenManage Essentials installations to run on same instance of
SQL Server database .................................................................................................. 4
Setting Up Multiple OpenManage Essentials Installations on a Single SQL Server Instance ................ 5
First Approach: Back Up and Restore ............................................................................ 6
Second Approach: Using MDF/LDF Files .......................................................................... 9
Removing the Connection Between OpenManage Essentials and the Database ........................ 11
Common Problem During Back-Up/Restore Process ........................................................... 17
Conclusion .............................................................................................................. 17
Figures
Figure 1. Installing OpenManage Essentials on a Local Server Without SQL ................................. 5
Figure 2. Creating a Back-Up of the OpenManage Essentials Database ...................................... 6
Figure 3. Final Step in Creating a Back Up of the OpenManage Essentials Database ...................... 7
Figure 4. Restoring the Database ................................................................................... 8
Figure 5. Restoring the Back Up of OpenManage Essentials Database ........................................ 9
Figure 6. Taking the OpenManage Essentials Database Offline .............................................. 10
Figure 7. Attaching the OpenManage Essentials Database Using MDF/LDF Files .......................... 11
Figure 8. Changing the Account Password for the OpenManage Essentials Database .................... 12
Figure 9. Changing the Status of OpenManage Essentials Database ........................................ 13
Figure 10. Connection is Lost Between OpenManage Essentials and the Database ........................ 14
Figure 11. Database Retargeting to the Centralized SQL Database .......................................... 14
Figure 12. Changing the Registry Value Under Database ....................................................... 15
Figure 13. Changing the Registry Value Under UserDefined ................................................... 16
Figure 14. Restarting OpenManage Essentials Services From the Preferences page....................... 16
Figure 15. Microsoft SQL error which might occur during back-up and restore process .................. 17
Figure 16. Changing the details for restore to point to correct database back-up ........................ 17
(21 stránky)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce