While trying to add a Domain Manager to an Enterprise Server the following error occurs:
Cannot Add a Domain to Enterprise [CMM000267]
The following lines are seen in the TRC_GUI log on the Enterprise Manager:
271016-15:09:54.7936412L|000868|00001260|GUI |CFUtilities_Help|CFUtilities_Helper |000000|DETAIL | Lookup of camsqlmdb.abc.com.au was not found from short name using camsqlmdb
271016-15:09:54.7936746L|000868|00001260|GUI |CDb |CDb.cpp |000300|INFO | *** camsqlmdb.abc.com.au could not be translated to an address
271016-15:10:24.7987209L|000868|00001260|GUI |DbImpl_Ado |DbImpl_Ado.cpp |002311|NOTIFY | evalSQLInfo sqlstate: 08001 native error: 11001 0x2af9
271016-15:10:24.7987694L|000868|00001260|GUI |DbImplAdo |DbImpl_Ado.cpp |002345|NOTIFY | evalSQLInfo description: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. source: Microsoft SQL Server Native Client 10.0
271016-15:10:24.7988074L|000868|00001260|GUI |DbImpl_Ado |DbImpl_Ado.cpp |002311|NOTIFY | evalSQLInfo sqlstate: 08001 native error: 11001 0x2af9
271016-15:10:24.7988376L|000868|00001260|GUI |DbImplAdo |DbImpl_Ado.cpp |002345|NOTIFY | evalSQLInfo description: TCP Provider: No such host is known.
This error occurs due to one of the following reasons:
1. Hostname resolution
Make sure that you are able to ping the hostname of the Domain Manager MDB server. If there are DNS resolution issues, add an entry for the Domain Manager's MDB server in the hosts file of the Enterprise Server.
2. SQL Server Browser service disabled.
If the Domain Manager MDB is hosted on a named instance, make sure that the SQL Browser service is running.
3. Ports not open
The following ports 4104, 4105, 4728 and 1433 (SQL port) should be open bi-directional between the Enterprise Server and the Domain Manager.
These are communication ports and need to be open before adding a new domain.
Note: If SQL server is running on a non-default port, that port needs to be open.