Enterprise and Domains open the same DSM Explorer / Instance (12.9)

[Legacy User]

Hi everyone, I hope you guys can help about this problem. I'm preparing a new environment using ITCM 12.9. The new environment is going to be like that:

 

Enterprise Manager - Hostname2060 - Windows Server 2012

Domain Manager 01 - Hostname2041 - Windows Server 2012

Domain Manager 02 - Hostname2042 - Windows Server 2012

Domain Manager 03 - Hostname2043 - Windows Server 2012

Domain Manager 04 - Hostname2044 - Windows Server 2012

 

16 Scalability Servers - Windows Server 2012

 

We have a Database with a SQL Server 2012 instance for Enterprise and each Domain, for example:

 

Enterprise Manager - Database\Instance = database\ITCMEM

Domain Manager 01 - Database\Instance = database\ITCMA

Domain Manager 02 - Database\Instance = database\ITCMB

Domain Manager 03 - Database\Instance = database\ITCMC

Domain Manager 04 - Database\Instance = database\ITCMD

 

I installed CA MDB in each instance. Then I installed Enterprise Manager linking to database\ITCMEM and Domain Manager 02 linking to database\ITCMB and Domain Manager 02 linking to database\ITCMD.

 

The problem is:

 

When I open DSM Explorer on Enterprise Manager or on Domain 02, they open the same DSM Explorer of Domain Manager 04 (linked to ITCMD).

During the installation of Enterprise I set ITCMEM as instance. After the installation it appeared ok, but after install Domain 04 I open DSM Explorer on Enterprise and it opens the same DSM Explorer of Domain 04 (linked to instance ITCMD)

 

The same happens with Domain 2. During the installation I set ITCMB as instance, but after install Domain 04 I open DSM Explorer on Domain 02 and it opens the same DSM Explorer of Domain 04 (linked to instance ITCMD)

 

Please check examples attached.

Attachment(s)

Enterprise and Domains open the same DSM Explorer Instanc...9   252 KB 1 version

[Matt_Godfrey]

Hi,

Reading your post I am confused on one thing, is each mdb installed on it's own

server or on the same machine?

Matt

[Legacy User]

Hi Matthew, first of all, thanks for answering.

 

All the instances are installed on the same machine (SQL Server 2012)

 

Ex:

 

Database\instance:

 

hostname949\ITCMEM

hostname949\ITCMA

hostname949\ITCMB

hostname949\ITCMC

hostname949\ITCMD

 

It's the same database, but we have one instance for Enterprise (ITCMEM) and for each domain (ITCMA, ITCMB, ITCMC and ITCMD).

 

I hope I have been clearer right now.

 

Thanks again.

[Steve Parker]

Open the DSM Explorer and then right click on the “DSM Explorer” and select browser domain.

 

 

 

Enter the name of you Enterprise Server.

 

Then right click in the DSM Explorer on the ES server and select “Set as default Domain”

 

 

 

Then when you open the explorer it should default to the ES.

 

The DSMGUI also has command line options that allow you to specify the server you want it to connect to when starting.

 

Rgds,

Steve.

[Legacy User]

Hi, thanks for helping.

 

I just did what you suggested but I received the error message below:

 

Own domain not found [SDM0004222]

 

I did some research on the CA Support online and on the web and I did not find anything about this error.

[Steve Parker]

I can’t find that message. Please supply a screen shot.

[Legacy User]

Hi, I just attached the screen shot, thank you!

 

[Steve Parker]

That is strange. I tested it on my system and it works fine.

[Steve Parker]

The setting is held in the registry. See screen shot.

 

 

[Gordon Lamothe]

Can you try the name of the box the DM is on, not the name of the Manager.

 

Does that work ?

[Legacy User]

I'm sorry Gordon, I did not understand what you asked for.

 

Could please clarify it?

 

Thank you.

[Gordon Lamothe]

When you open DSM Explorer, the name will show the name of the Remote SQL server it is attached to.

 

BUT if you do hostname in cmd prompt it will show the actual name of the server you are on.

 

Can you open attach to the actual server name ?

[Legacy User]

Hi everyone.

 

I finally found the problem. All DSM Explorer was using the same port (1433). Even they were linked to different instances however all instances are at the same database.

 

Solution: I left all TCP Ports of instances in blank and all TCP Dynamic Ports with 0 (zero) value. So after restart instances service, SQL Configuration Server provided a number of dynamic port.

 

Finally I reinstalled Enterprise and Domains setting the ports that SQL Configuration Server provided. So it worked fine.

 

Now, I’m gonna set the number of port as fixed to avoid that other application uses the same port.

 

I would like to thank you everybody for spending time helping me. I appreciate that. See you.