troubleshooting Question

DB2 cannot create database err=SQL1092N as a domain user

Avatar of choracy
choracyFlag for Cyprus asked on
DB2
12 Comments2 Solutions4893 ViewsLast Modified:
I have very little DB2 experience.

I've just installed DB2 9.7 FP4 on Win2008R2x64 using a Domain account having local Admin privileges. (setup.exe "Run as Administrator").

Selected Server authentication. Local Groups and accounts for DB2 were created.

Added domain account to local DB2ADMNS and DB2USERS.

I tried almost all possible values and combinations for DB2_GRP_LOOKUP (local, token, domain) but could not create a database.

Got the error : SQL1092N  "SVC_USER  " does not have the authority to perform the requested command or operation.

I suppose logging on windows as DB2Admin will create the database ok, also if I start the DB2 instance as the domain SVC_USER, will allow database creation but I do not want to try either.

Need a way to be able to create databases using the SVC_USER domain account.
ASKER CERTIFIED SOLUTION
Kent Olsen
Data Warehouse / Database Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros