NTUSERNAME does not have authority (was "Help!!!!!!!!!!!!!!!!!")

dirtydavey · #1 (**permalink**) 11-21-07, 11:22

Just installed db2 for the first time. Never used it before ever. (I am a MSSQL server DBA, leavring db2) Installed it fine, but cant do nay thing with out tyhe following error.

SQL1092N "NTUSERNAME" does not have the authority to perform the
requested command.

What am I doing, this is a bad start for me.

ARWinner · #2 (**permalink**) 11-21-07, 11:47

I assume you are using DB2 on Windows. If not, which OS? And which DB2 version.?

My guess is that you have not given NTUSERNAME any rights to use the DB2 system.

Andy

dirtydavey · #3 (**permalink**) 11-21-07, 11:50

Yes sorry its on windows server 2003. Its DB2 express-c with no fixpack.

Its very possible I have not given it the right user rights. How do I do this?

ARWinner · #4 (**permalink**) 11-21-07, 11:55

As the instance owner (you should have created one when you installed the system):

1) connect to the DB
2) issue "grant" commands to allow whatever rights are necessary.

Andy

dirtydavey · #5 (**permalink**) 11-21-07, 11:59

I did not get given the options. But I cant even see any databases right now

ARWinner · #6 (**permalink**) 11-21-07, 12:38

Check the Users on your server and see if there is anything with DB2 in the name. If so, this will be your instance owner. If not, you will need to create an instance with the db2icrt command (it is in the manual).

Then as the instance owner, you can create a database using either the command line (see CREATE DATABASE command) or the GUI Control Center.

Andy

dirtydavey · #7 (**permalink**) 11-22-07, 09:15

I have a group called db2admin and db2users. I have added my self to both groups. Still no luck. Hmm I know its somthing silly!

Marcus_A · #8 (**permalink**) 11-22-07, 10:09

Check the install guide for information about authorization required on the id used to install DB2. Under Windows, it is much trickier than under Linux, UNIX becasue DB2 wants the user to have administrator authority. I am not sure which version you are using, but at one time if your userid was part of a domain, it had to be the domain administrator.

However, you may be able to go into Window Services and specify which userid you want DB2 to logon with to resolve the problem.

dirtydavey · #9 (**permalink**) 11-22-07, 10:24

Hi, thats great thanks, its a fix of sorts. I have got the service to log in as the same account I log into windows with. This now works, and will at least let me get a feel for db2.