Trusted Connection on Windows Environment

Posted in 2017

Summary

Mukesh Tanuku could not get a trusted connection working for HDR on Windows; onstat -g dri showed HDR OFF and the log said the secondary connection failed. Mike Walker and David pointed to hosts.equiv in the Windows drivers\\etc folder on both hosts. Mukesh had already created it and said the link did not work; Mike supplied a short link. Unresolved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: High Availability & Replication, Networking & sqlhosts Configuration, Platform-Specific Issues

MUKESH TANUKU — Tue, 27 Jun 2017 17:32:54 — source: IIUG Forums & Mailing Lists

Hello All, How to establish trusted connection to implement HDR on Windows server. Please need in detail steps, since last 1 month im trying but no solution. SQLHOSTS, hosts files are placed in %INFORMIXDIR%\\\\etc Please any one help me

↪ replying to MUKESH TANUKU

Mike Walker — Tue, 27 Jun 2017 17:41:48 — source: IIUG Forums & Mailing Lists

Did you set up hosts.equiv, as described here: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.d oc/ids_admin_1407.htm How do you know that it's a trust issue and not a firewall problem or something? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUKESH TANUKU Sent: Tuesday, June 27, 2017 11:33 AM To: ids@iiug.org Subject: Trusted Connection on Windows Environment [39458] Hello All, How to establish trusted connection to implement HDR on Windows server. Please need in detail steps, since last 1 month im trying but no solution. SQLHOSTS, hosts files are placed in %INFORMIXDIR%\\\\etc Please any one help me **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to MUKESH TANUKU

david@smooth1.co.uk — Tue, 27 Jun 2017 21:50:07 — source: IIUG Forums & Mailing Lists

I had already provided an answer weeks ago. http://smooth1.co.uk/installs/dbinstalls.html#3.2.2 - Create c:\\\\Windows\\\\System32\\\\drivers\\\\etc\\\\hosts.equiv on both hosts and add hostname of the other server Regards, David. > On 27 June 2017 at 18:32 MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > > > Hello All, > > How to establish trusted connection to implement HDR on Windows server. > > Please need in detail steps, since last 1 month im trying but no solution. > > SQLHOSTS, hosts files are placed in %INFORMIXDIR%\\\\etc > > Please any one help me > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Mike Walker

MUKESH TANUKU — Wed, 28 Jun 2017 17:27:04 — source: IIUG Forums & Mailing Lists

Hello Mike, Thanks for your response. I ahve set the hosts.equiv file on both servers Location: C:\\\\Windows\\\\System32\\\\drivers\\\\etc\\\\ hosts.equiv file contains hostname and user I know that this is a trust connection problem, from DBACCESS it is connecting but promting for username and password. an also in Message log it say that connecting to secondary failed. After HDR setup the output of onstat -g dri says that the HDR status is OFF. so from this icame to know that this is a trust connection problem. And the website you mentioned is not working.

↪ replying to MUKESH TANUKU

Mike Walker — Wed, 28 Jun 2017 18:07:23 — source: IIUG Forums & Mailing Lists

The link works - it just gets split over lines when posted to the board. Here's a tinyurl instead: http://tinyurl.com/y6twgnnu There have been multiple replies to your question, including detail, which should help you get this done. Mike -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUKESH TANUKU Sent: Wednesday, June 28, 2017 11:27 AM To: ids@iiug.org Subject: Re: RE: Trusted Connection on Windows Environment [39471] Hello Mike, Thanks for your response. I ahve set the hosts.equiv file on both servers Location: C:\\\\Windows\\\\System32\\\\drivers\\\\etc\\\\ hosts.equiv file contains hostname and user I know that this is a trust connection problem, from DBACCESS it is connecting but promting for username and password. an also in Message log it say that connecting to secondary failed. After HDR setup the output of onstat -g dri says that the HDR status is OFF. so from this icame to know that this is a trust connection problem. And the website you mentioned is not working. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads

Glossary

HDR
sqlhosts