MSDTC issue

Hi All

    I had create a topic to ask MSDTC , and I find the MSDTC need been configured on both (DB and agent manager).

but now I install production server, I indeed configured DTC properties on both sides...then set firewall like below:

SAM <==> DB TCP 1024-65535 (MSDTC)

SAM <==> DB TCP 135 (MSDTC)

SAM ==> DB TCP 1433 (MSSQL)

SAM ==> DB UDP 1434 (MSSQL Browser)

I also use DTCPing tool on both to check MSDTC communication .....both side DTCPing tool show success.

but agent manager installation program set DB server....it still show MSDTC problem.

which configure parameter I forgot or which log file that I could get detail information ??

Thanks!!

Wencheng

Tags:

  • 0  

    I guess you are referring to the point in the installation where you input the DB Server Name and select next, but it throws and error e.g. "Agent Manager could not connect to the Agent Manager database server ....."?  When I've see this it has always either been the firewall or the MSDTC configuration.  These are my notes rom a few years ago:

    Firewall - One of the problems with MSDTC is that it uses a random high port and in the past (as per the above) I've had to configure MSDTC to use specific ports for this, but you are opening 1024-65535 in both directions, which should work just as well.  However, as a test, if you can disable the firewall on both sides (Central Computer, DB Server) then retry the install, but don't complete the config, you just want to see if it goes past the DB connection error.  If it does, then your issue is the firewall.  If it doesn't, then the issue is probably be the MSDTC config.

    MSDTC - As per the above, have you enabled "Network DTC Access", "Allow Remote Clients", "Allow Inbound", "Allow Outbound", and """Mutual Authentication Required" on both sides (Central Computer, DB Server) of the communication?

       

  • 0 in reply to   

    HI  

        Abut MSDTC setting ...Yes...my Settinig same like  you provide. and I also useing DTCPing tool on both server to check .

    each side DTCPing show success.

        About firewall, as I list on first post.....it sholuld include all port like you list when agent manager install. 

    (Two way) SAM <==> DB TCP 1024-65535 (MSDTC)

    (Two way) SAM <==> DB TCP 135 (MSDTC)

    (One Way) SAM ==> DB TCP 1433 (MSSQL)

    (One Way) SAM ==> DB UDP 1434 (MSSQL Browser)

    I also use the same administrator password to both server...but install program still show MSDTCerror.

    But I find a "waning" message on windows application event. the hostname is itself

    other question...about AV ecclude...which file need exclude ? setup.exe ??

    Wencheng

  • 0   in reply to 

    Sorry, I don't know what that error means, but I guess it could suggest the issue is with MSDTC.  Perhaps re-check yourt config.  However, if you disable the firewalls and try the install as I suggested, then at least you could confirm that.  That would tell you where to focus your troubleshooting.  Whenever I've setup SAM I've followed those notes and it the install has gone though fine.

    The SAM documentation tells you what should be excluded with respect to the AntiVirus:

    https://www.microfocus.com/documentation/sentinel/8.6/sam86_install/b13uoyn0.html

  • 0 in reply to   

    Hi 

       this list is "After Install", but I want to know "When Install".

    and I find a interesting thing

    =====================================

    The document mentions that the account used by Agent Manager to execute the installation program must also have the DB Administrator (Sysadmin role) on the remote MSSQL host?? I don’t seem to see this requirement??

    =====================================

    Is there really any mention of grandma in the document??

    Wencheng

  • Suggested Answer

    0   in reply to 

    https://www.microfocus.com/documentation/sentinel/8.6/sam86_install/b13uoytp.html

    "Before installing Sentinel Agent Manager, ensure your logon account is a member of the local Administrators group on the computers where you install Sentinel Agent Manager components. Also ensure your logon account is a member of the Microsoft SQL Server sysadmin role on the database server."

  • 0 in reply to   

    you are correct

       In addition to setting DTC settings for component services (including firewall)
    You also need to configure the Windows account used to install the Agent Manager program to have sysadmin permissions for MSSQL.