Dell EMC OpenManage Essentials Version 2.5 User's Guide

Setting up OpenManage Essentials Database on a Remote SQL Server

You can configure OpenManage Essentials to use an SQL Server present on a remote system. Before setting up the OpenManage Essentials database on the remote system, check for the following prerequisites:
  • Network communication between the OpenManage Essentials system and the remote system is functioning.
  • SQL connection works between the OpenManage Essentials system and the remote system for the specific database instance. You can use the Microsoft SQL Server Express 2012 Management Studio tool to verify the connection. On the remote database server, enable TCP/IP protocol and if you are using SQL Authentication, enable mixed mode on the remote SQL Server.
You can retarget the database if:
  • SQL credential to the SQL Server fails.
  • Windows credential to the SQL Server fails.
  • Login credentials have expired.
  • Database is moved.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\