Windows Domain Problems

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • george

    Windows Domain Problems

    Hello,

    I have installed DB2 on a Windows2000 system. I set the authentication
    to client and have all clients trusted.

    I can not seem to connect to the database as the user logged into the
    database. In other words if I am logged into the network as user-a, I
    can connect to the database as user-b but not as user-a. If I log on
    to the network as user-b then I can connect to the database as user-a
    but not user-b. This occurs on workstations or on the server.

    The network is a single domain network.

    Any suggestions on how to fix this?
  • Mark A

    #2
    Re: Windows Domain Problems

    "george" <gmclean@rrsyte c.com> wrote in message
    news:b32362a2.0 310201744.7a728 e8@posting.goog le.com...[color=blue]
    > Hello,
    >
    > I have installed DB2 on a Windows2000 system. I set the authentication
    > to client and have all clients trusted.
    >
    > I can not seem to connect to the database as the user logged into the
    > database. In other words if I am logged into the network as user-a, I
    > can connect to the database as user-b but not as user-a. If I log on
    > to the network as user-b then I can connect to the database as user-a
    > but not user-b. This occurs on workstations or on the server.
    >
    > The network is a single domain network.
    >
    > Any suggestions on how to fix this?[/color]

    If the user id that was used to install DB2 was more than 8 characters, you
    need to uninstall and install again. In addition to being 8 or less
    characters, the install user should have domain administrator authority.


    Comment

    • Gert van der Kooij

      #3
      Re: Windows Domain Problems

      In article <Op0lb.949$BF1. 131319@news.usw est.net>, ma@switchboard. net
      says...
      [color=blue][color=green]
      > > The network is a single domain network.
      > >
      > > Any suggestions on how to fix this?[/color]
      >
      > If the user id that was used to install DB2 was more than 8 characters, you
      > need to uninstall and install again. In addition to being 8 or less
      > characters, the install user should have domain administrator authority.
      >
      >[/color]

      On Windows it's not the username but the group which must be 8 or
      less characters, check http://tinyurl.com/rrwe .

      Comment

      • Mark Yudkin

        #4
        Re: Windows Domain Problems

        On the server DB2 must run under a suitable non-SYSTEM domain account. See
        docs for full privilege list.
        On the client, DB2 Security Service must be started (Startup
        Type=Automatic) .
        User must be logged on to the domain (domain\user-a).

        "george" <gmclean@rrsyte c.com> wrote in message
        news:b32362a2.0 310201744.7a728 e8@posting.goog le.com...[color=blue]
        > Hello,
        >
        > I have installed DB2 on a Windows2000 system. I set the authentication
        > to client and have all clients trusted.
        >
        > I can not seem to connect to the database as the user logged into the
        > database. In other words if I am logged into the network as user-a, I
        > can connect to the database as user-b but not as user-a. If I log on
        > to the network as user-b then I can connect to the database as user-a
        > but not user-b. This occurs on workstations or on the server.
        >
        > The network is a single domain network.
        >
        > Any suggestions on how to fix this?[/color]


        Comment

        Working...