Professional Web Applications Themes

SQL4412N The logon user account for the DB2 Administration Server is invalid. - IBM DB2

Did you use DB2SET to set DB2_GRP_LOOKUP=local for the admin instance? Is the Admin Server running under a local or a domain account? How is the instance's authentication parameter set? When you say you logged on using the DB2 install user id, is that a domain or a local userid? Please post adequate security configuration information so we can yse this one. [It is also unusual to run DB2 enterprise edition on a Windows 2000 workstation, normally you'd use a Windows server for DB2 EE] "Pat Whalen" <redmudpobox.com> wrote in message news:4zmPa.28610$EQ5.8279twister.nyroc.rr.com... > I am using DB2 enterprise edition on ...

  1. #1

    Default Re: SQL4412N The logon user account for the DB2 Administration Server is invalid.

    Did you use DB2SET to set DB2_GRP_LOOKUP=local for the admin instance? Is
    the Admin Server running under a local or a domain account? How is the
    instance's authentication parameter set? When you say you logged on using
    the DB2 install user id, is that a domain or a local userid?

    Please post adequate security configuration information so we can yse
    this one.

    [It is also unusual to run DB2 enterprise edition on a Windows 2000
    workstation, normally you'd use a Windows server for DB2 EE]

    "Pat Whalen" <redmudpobox.com> wrote in message
    news:4zmPa.28610$EQ5.8279twister.nyroc.rr.com...
    > I am using DB2 enterprise edition on a Windows 2000 workstation.
    >
    > The db2level is:
    > DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08012"
    with
    > level identifier "02030106".
    > Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
    FixPak
    > "2".
    >
    > I have logged into Windows with the same id that was used to install DB2
    in
    > the first place.
    >
    > Might anyone be able to give me some idea what the problem is here?
    >
    > Thank you in advance.
    >
    > Pat
    >
    >

    Mark Yudkin Guest

  2. #2

    Default Re: SQL4412N The logon user account for the DB2 Administration Server is invalid.

    Thanks for responding.

    Here is what I get when I enter "db2set":

    DB2ACCOUNTNAME=MYCOMP\MyNtId
    DB2INSTOWNER=AB-00077777
    DB2PORTRANGE=60000:60003
    DB2_GRP_LOOKUP=LOCAL
    DB2INSTPROF=C:\PROGRA~1\IBM\SQLLIB
    DB2COMM=TCPIP

    (Note that the actual id's have been changed due to this being an open
    forum)

    I am connected as MYCOMP\MyNtId. The install and usage were all performed
    using this id.

    Looking at this information I wonder if the instance owner which is my
    machine name being different from the domain name I am connected with is
    this issue.

    I am going to try and log on under my machine name to see if I can then
    start the administration server.

    Pat

    "Mark Yudkin" <myudkinATcompuserveDOTcomnospam.org> wrote in message
    news:bels9t$pp3$1ngspool-d02.news.aol.com...
    > Did you use DB2SET to set DB2_GRP_LOOKUP=local for the admin instance? Is
    > the Admin Server running under a local or a domain account? How is the
    > instance's authentication parameter set? When you say you logged on using
    > the DB2 install user id, is that a domain or a local userid?
    >
    > Please post adequate security configuration information so we can yse
    > this one.
    >
    > [It is also unusual to run DB2 enterprise edition on a Windows 2000
    > workstation, normally you'd use a Windows server for DB2 EE]
    >
    > "Pat Whalen" <redmudpobox.com> wrote in message
    > news:4zmPa.28610$EQ5.8279twister.nyroc.rr.com...
    > > I am using DB2 enterprise edition on a Windows 2000 workstation.
    > >
    > > The db2level is:
    > > DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08012"
    > with
    > > level identifier "02030106".
    > > Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
    > FixPak
    > > "2".
    > >
    > > I have logged into Windows with the same id that was used to install DB2
    > in
    > > the first place.
    > >
    > > Might anyone be able to give me some idea what the problem is here?
    > >
    > > Thank you in advance.
    > >
    > > Pat
    > >
    > >
    >
    >

    Pat Whalen Guest

  3. #3

    Default Re: SQL4412N The logon user account for the DB2 Administration Server is invalid.

    Hi Pat,

    reading the naming rules, you can't use a hypen for the instance:

    [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infoce[/url]
    nter.d2w/report?target=mainFrame&fn=c0007245.htm

    Unless otherwise specified, all names can include the following
    characters:
    a.. A through Z. When used in most names, characters A through Z are
    converted from lowercase to uppercase.
    b.. 0 through 9
    c.. , #, $, and _ (underscore)
    Names cannot begin with a number or with the underscore character.




    Regards,
    Joachim
    "Pat Whalen" <redmudpobox.com> schrieb im Newsbeitrag
    news:4zmPa.28610$EQ5.8279twister.nyroc.rr.com...
    > I am using DB2 enterprise edition on a Windows 2000 workstation.
    >
    > The db2level is:
    > DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08012"
    with
    > level identifier "02030106".
    > Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
    FixPak
    > "2".
    >
    > I have logged into Windows with the same id that was used to install DB2
    in
    > the first place.
    >
    > Might anyone be able to give me some idea what the problem is here?
    >
    > Thank you in advance.
    >
    > Pat
    >
    >

    Joachim Müller Guest

  4. #4

    Default Re: SQL4412N The logon user account for the DB2 Administration Server is invalid.

    Sorry,
    came from UNIX where the instance owner is like the instance.
    What's your about your DB2INSTOWNER=AB-00077777

    Have a look at this?

    Regards,
    Joachim

    "Pat Whalen" <redmudpobox.com> schrieb im Newsbeitrag
    news:LhzPa.32615$EQ5.5590twister.nyroc.rr.com...
    > The instance name is "DB2". The machine name has a hyphen in the third
    > position but I wouldn't expect that to be a problem.
    >
    > p.s. I tried connecting under the local domain and received the same
    error.
    >
    > Thanks for responding. I appreciate any help I can get in this.
    >
    > Pat
    >
    > "Joachim Müller" <j.muellerdouglas-informatik.de> wrote in message
    > news:bemhk4$5d8$1news.dtag.de...
    > > Hi Pat,
    > >
    > > reading the naming rules, you can't use a hypen for the instance:
    > >
    > >
    >
    [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infoce[/url]
    > > nter.d2w/report?target=mainFrame&fn=c0007245.htm
    > >
    > > Unless otherwise specified, all names can include the following
    > > characters:
    > > a.. A through Z. When used in most names, characters A through Z
    are
    > > converted from lowercase to uppercase.
    > > b.. 0 through 9
    > > c.. , #, $, and _ (underscore)
    > > Names cannot begin with a number or with the underscore character.
    > >
    > >
    > >
    > >
    > > Regards,
    > > Joachim
    > > "Pat Whalen" <redmudpobox.com> schrieb im Newsbeitrag
    > > news:4zmPa.28610$EQ5.8279twister.nyroc.rr.com...
    > > > I am using DB2 enterprise edition on a Windows 2000 workstation.
    > > >
    > > > The db2level is:
    > > > DB21085I Instance "DB2" uses "32" bits and DB2 code release
    "SQL08012"
    > > with
    > > > level identifier "02030106".
    > > > Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
    > > FixPak
    > > > "2".
    > > >
    > > > I have logged into Windows with the same id that was used to install
    DB2
    > > in
    > > > the first place.
    > > >
    > > > Might anyone be able to give me some idea what the problem is here?
    > > >
    > > > Thank you in advance.
    > > >
    > > > Pat
    > > >
    > > >
    > >
    > >
    >
    >

    Joachim Müller Guest

  5. #5

    Default Re: SQL4412N The logon user account for the DB2 Administration Server is invalid.

    The problem now seems to be resolved. I am still not entirely sure what
    happened but here is what seemed to fix it.

    To fix the administration server I entered the commands:

    db2admin drop
    db2admin create /user:MyNtId /password:myPassword

    I expect "db2admin set myuserid mypassword" would have worked as well.

    Thanks for the insights.

    "Joachim Müller" <j.muellerdouglas-informatik.de> wrote in message
    news:bemlr9$kdi$1news.dtag.de...
    > Sorry,
    > came from UNIX where the instance owner is like the instance.
    > What's your about your DB2INSTOWNER=AB-00077777
    >
    > Have a look at this?
    >
    > Regards,
    > Joachim
    >
    > "Pat Whalen" <redmudpobox.com> schrieb im Newsbeitrag
    > news:LhzPa.32615$EQ5.5590twister.nyroc.rr.com...
    > > The instance name is "DB2". The machine name has a hyphen in the third
    > > position but I wouldn't expect that to be a problem.
    > >
    > > p.s. I tried connecting under the local domain and received the same
    > error.
    > >
    > > Thanks for responding. I appreciate any help I can get in this.
    > >
    > > Pat
    > >
    > > "Joachim Müller" <j.muellerdouglas-informatik.de> wrote in message
    > > news:bemhk4$5d8$1news.dtag.de...
    > > > Hi Pat,
    > > >
    > > > reading the naming rules, you can't use a hypen for the instance:
    > > >
    > > >
    > >
    >
    [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infoce[/url]
    > > > nter.d2w/report?target=mainFrame&fn=c0007245.htm
    > > >
    > > > Unless otherwise specified, all names can include the following
    > > > characters:
    > > > a.. A through Z. When used in most names, characters A through Z
    > are
    > > > converted from lowercase to uppercase.
    > > > b.. 0 through 9
    > > > c.. , #, $, and _ (underscore)
    > > > Names cannot begin with a number or with the underscore character.
    > > >
    > > >
    > > >
    > > >
    > > > Regards,
    > > > Joachim
    > > > "Pat Whalen" <redmudpobox.com> schrieb im Newsbeitrag
    > > > news:4zmPa.28610$EQ5.8279twister.nyroc.rr.com...
    > > > > I am using DB2 enterprise edition on a Windows 2000 workstation.
    > > > >
    > > > > The db2level is:
    > > > > DB21085I Instance "DB2" uses "32" bits and DB2 code release
    > "SQL08012"
    > > > with
    > > > > level identifier "02030106".
    > > > > Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
    > > > FixPak
    > > > > "2".
    > > > >
    > > > > I have logged into Windows with the same id that was used to install
    > DB2
    > > > in
    > > > > the first place.
    > > > >
    > > > > Might anyone be able to give me some idea what the problem is here?
    > > > >
    > > > > Thank you in advance.
    > > > >
    > > > > Pat
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >

    Pat Whalen Guest

Similar Threads

  1. How to allow a user account local login to server?
    By tmeier in forum Windows Server
    Replies: 2
    Last Post: June 22nd, 09:20 PM
  2. Server 2003 User Account Issues
    By Greg in forum Windows Server
    Replies: 1
    Last Post: June 4th, 12:02 AM
  3. IIS not passing NT logon user ID to SQL Server
    By Henry Calo in forum ASP Database
    Replies: 1
    Last Post: August 12th, 06:30 PM
  4. Unable to logon to the main administrator account on XP
    By Christina in forum Windows Setup, Administration & Security
    Replies: 0
    Last Post: July 13th, 09:36 PM
  5. Logon and Welcome screen problems with the Administrator account
    By Marisa in forum Windows Setup, Administration & Security
    Replies: 2
    Last Post: July 3rd, 01:13 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139