VVP: Not trusted [Archive]

vprasad

03-06-02, 13:12

Hello,

I am not a DBA but use sql frequently.

I am trying this code:

insert into dest1@db_1:names
select * from name

and get this error:

or user is not trusted by the database server

I am on server dest2

Any idea how to fix this?

Thanks,

V

chulapat

03-18-02, 21:23

:o
Which operating system you use ?..
This problem is solved by adding hosts.equiv files on both servers. hosts.equiv file make
one server trust one another.

If you use Windows NT or 2000 for your server, host.equiv file will be located in
/winnt/system32/drivers/etc/hosts.equiv

If you use Linux or Solaris or other unix operating systems, hosts.equiv will be located in
/etc

hosts.equiv file format is begin with "+" and follow with hosts name (or ipaddress) you would like to trust on another line of file.

for example: If I want to make my database server trust database server named SUNNY
I will create hosts.equiv file

+
SUNNY

or
+
203.184.25.223