user permission problem while creating DB2 instance
qazml...@rediffmail.com
time (It was much easier when I did for the mySQL).
I installed the DB2-Express (free version) on my WindowsXP PC, as per
the installation instructions.
My user name is 'DB2TESTER' and this user id is in the domain of my
company intranet JNS-INTRA.
When the installation setup prompted, I selected 'Local user or Domain
user' option and I entered 'DB2TESTER' (without selecting the domain
JNS-INTRA) and I created a new password. It went through successfully.
After the installation, I clicked on 'Create SAMPLE Database' in the
'DB2 First steps' window. It throws the following error:
Attempt to create the database "SAMPLE" failed.
SQL1092N "DB2TESTER" does not have the authority to perform the
requested command or operation.
I even tried creating a new instance, and the same error is reported.
This is what I got during the installation:
-----
New instances:
Instance name: DB2
Start instance on reboot: Yes
TCP/IP configuration:
Service name: db2c_DB2
Port number: 50000
Instance user information:
User name: db2tester
DB2 Administration server:
Instance user information:
User name: db2tester
-----
Do you have a hint on WTH is the problem here?
Mark A
news:badbb719-c233-4f3f...@i6g2000yqj.googlegroups.com...
DB2 is a little tricky when installed on a Windows Domain because DB2 uses
the OS security, and not its own database security. Go into Windows Services
and select "Properties" for the DB2 -DB2_V95 or 97 or whatever (probably the
first DB2 in the list) and go to "Log On" tab.
In the "Log On" tab, select the radio button for "This account" and use
DB2TESTER as the id (also enter the password). It might automatically change
to .\DB2TESTER after you hit the OK button.
Now go back to First Steps and recreate the sample database.
Don't forget the DB2 Express-C forum on the IBM website which has a lot of
valuable DB2 Express-C specific information and helpful people there.
http://www.ibm.com/developerworks/forums/forum.jspa?forumID=805
qazml...@rediffmail.com
> <qazmlp1...@rediffmail.com> wrote in message
Thanks for the information. But, the setting you suggested is already
there for me.
'This account' already contains .\DB2TESTER.
Now, I'm more puzzled about how to solve this crazy problem.
Once this problem is solved here, later I'll start participating in
the forum that you have mentioned. Thanks!
qazml...@rediffmail.com
>
> Thanks for the information. But, the setting you suggested is already
> there for me.
>
> 'This account' already contains .\DB2TESTER.
>
> Now, I'm more puzzled about how to solve this crazy problem.
>
> Once this problem is solved here, later I'll start participating in
>
> - Show quoted text -
- uninstall DB2
- install DB2
-> used the domain account; I ignored this warning 'The domain ID
and password entered cannot be verified because domain administrator
privileges are required'.
-> I got the 'PROCESS_ERROR' twice during the installation. I
ignored these too.
-> installation was successful
But, I faced the same problem ('does not have the authority') like
earlier. I don't know WTH was the problem.
Then, I retried the same thing:
- uninstall DB2; Here, I ensured that there are DB2 processes running
after the installation.
- install DB2
-> used the domain account; I ignored this warning 'The domain ID
and password entered cannot be verified because domain administrator
privileges are required'.
-> I didn't get any other error
-> installation was successful
- create SAMPLE database, was successful
- create new database, also was successful.
I seriously didn't understand what really happened. I found DB2
documentation also too bad, in this specific case.
So, if anybody wants to install DB2, try only with the domain account.
Nothing else works.
Serge Rielau
> So, if anybody wants to install DB2, try only with the domain account.
> Nothing else works.
Now on my laptop I use my administrator account.
The forum mark points you to is meant to be used to get help for
problems with DB2 Express C, not to celebrate once you have overcome
them ;-)
Cheers
Serge
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab