Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    2

    Smile Unanswered: Problem: configure DB2 to work in a LAN

    Hi, I'm an italian user, so I'm sorry for my basic english.
    I'll describe my problem:
    I must make a simulation of the working on a LAN with DB2.
    I have installed an istance on a Server (Windows Xp) and so the administrator of this machine became the DBADM of my DB (Sample, default after installing DB2) and have all authorities at instance and db level.
    After I have installed a copy of DB2 on a client machine, connected with server on a LAN with a Wifi router (the comunication between two pc is ok), catalog the node and the database on server.
    I have set on server (and on client) the dbm cfg parameter authentication on client because i don't want to add on my server S.O. all the LAN user. My problem is: if i create a user with the same username of server administrator (withouth PASSWORD) on the client machine, and try to connect with the command connect to demodb (demodb is the alias on client of Sample on server) so without password, the connection is OK. I wont this. How i set the two parameters TRUST_ALLCLNTS and TRUST_CLNTAUTH to eliminate my problem?
    Thanks a lot.
    Bye
    Stefano
    (I have the DB2 Express Edition 9.5)

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this is a db cfg parameter
    so at server :
    db2 update db cfg for sample using TRUST_CLNTAUTH client
    see
    trust_clntauth - Trusted clients authentication configuration parameter
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2009
    Posts
    2
    if i change the parameter TRUST_CLNTAUTH on dbm cfg I have the same problem. If I logon with a user with the same username of the DBADM (the administrator user of Server PC) my access in granted. Everyone can create a new user with the same name of DBADM on their own client and access the DB!!
    I try many combinations of the two parameter, but I have everytime the same problem.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    That's the idea of trusted clients though. If you don't trust your clients, authenticate at the server, but then you need to define user IDs on the server itself. Your choice.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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