Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    1

    Question Unanswered: VVP: Not trusted

    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

  2. #2
    Join Date
    Feb 2002
    Location
    Bangkok
    Posts
    11

    Wink


    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
    Erawan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •