Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance This Dell technical white paper explains how to redirect OpenManage Essentials to a system on a single SQL Server database instance so that one SQL Server database instance supports multiple OpenManage Essentials instances.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance This document is for informational purposes only and may contain typographical errors and technical inaccuracies. The content is provided as is, without express or implied warranties of any kind. © 2013 Dell Inc. All rights reserved. Dell and its affiliates cannot be responsible for errors or omissions in typography or photography. Dell, the Dell logo, and PowerEdge are trademarks of Dell Inc.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Contents Executive Summary ..................................................................................................... 4 Introduction .............................................................................................................. 4 Advantages of setting up multiple OpenManage Essentials installations to run on same instance of SQL Server database ............................................
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Executive Summary OpenManage Essentials is a one-to-many systems management tool which helps in monitoring servers, storage devices, printers, KVMs, UPSs, PDUs, chassis and network devices, etc. With the highest configuration supported (i.e. 8 GB RAM and 8 core processor) on the server running OpenManage Essentials, a maximum of 2000 devices can be monitored using OpenManage Essentials.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Setting Up Multiple OpenManage Essentials Instances on a Single SQL Server Instance 1. Install OpenManage Essentials on the remote or local database which is the centralized SQL server. For this example, let us assume it as OMEssentials1. 2. On another server, install OpenManage Essentials on a different local or remote database.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance First Approach: Back Up and Restore i. Launch SQL Server Management Studio and connect to the OpenManage Essentials database. ii. Right click Databases>>OMEssentials and click “Back Up” under “Tasks” as shown in Figure 2. Figure 2. Creating a Back-Up of the OpenManage Essentials Database iii. A window will open as shown in Figure 3.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Figure 3. v. Final Step in Creating a Back Up of the OpenManage Essentials Database Launch SQL Server Management Studio on the centralized SQL server and right-click “Databases” and select “Restore Database.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Figure 4. vi. Restoring the Database Enter the name of the database and provide the location of the back up database in the window that opens as shown in Figure 5.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Figure 5. vii. Restoring the Back Up of OpenManage Essentials Database Click “OK.” The new database should be created and shown under databases with the name as given by the administrator. Second Approach: Using MDF/LDF Files i. Identify the location of the mdf and ldf files: right-click the database and select “Properties”.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Figure 6. Taking the OpenManage Essentials Database Offline iii. Once the database is offline, open the location of the mdf/ldf files and copy the files. Change the name of the mdf and ldf files to anything other than OMEssentials.mdf and OMEssentials_1.mdf. Assume, OMEssentials2.mdf and OMEssentials2_1.ldf. iv. Copy these renamed mdf/ldf files to the centralized SQL server. v.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance viii. Figure 7. Click “OK”. The new database should be created and shown under databases with the name as given by the administrator. Attaching the OpenManage Essentials Database Using MDF/LDF Files 4. Remove the connection between second OpenManage Essentials and the database. This can be done as explained in the steps below. Removing the Connection Between OpenManage Essentials and the Database i.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Figure 8.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Figure 9. iv. Changing the Status of OpenManage Essentials Database Click “OK”. 5. Shut down the first OpenManage Essentials instance. Keep it off till the second OpenManage Essentials instance is up and running. 6. Once the connection between database and OpenManage Essentials is lost in the second OpenManage Essentials (i.e.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Figure 10. Connection is Lost Between OpenManage Essentials and the Database 7. Provide the IP or hostname of the centralized SQL database and the credentials as show in Figure 11. Click “Connect”. Figure 11. Database Retargeting to the Centralized SQL Database 8.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance server with the second OpenManage Essentials instance (i.e. OMEssentials2) using regedit in the Run console. 9. Change the key value for these “value name” as shown in Figure 12 to the name of the new database (i.e. OMEssentials2), so that it can point to the restored database. i. HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Dell Computer Corporation\Dell OpenManage Essentials\Database Figure 12. ii.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance Figure 13. Changing the Registry Value Under UserDefined 10. Restart OpenManage Essentials services from the Preferences page as shown in Figure 14. This is for setting up the odbc connection with the new database. Figure 14. Restarting OpenManage Essentials Services From the Preferences page 11. Reset IIS from the command prompt using the iisreset command. 12.
Setting Up Multiple OpenManage Essentials Instances on the Same SQL Server Database Instance 13. Start the first OpenManage Essentials instance, which should be pointing to its own database. Common Problem During Back-Up/Restore Process During the back up and restore process, there is a possibility of landing up on this common problem where SQL throws an error as shown in Figure 15. Figure 15.