| Author |
Message |
    
Kichidi
Celebrity Bewarse
Username: Kichidi
Post Number: 28422
Registered: 02-2010
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, October 26, 2012 - 5:02 pm: |
|
Stewie:Worked annai.. thanks for your help..
ITALIAN MAFIASO
|
Stewie
Kurra Bewarse
Username: Stewie
Post Number: 2732
Registered: 03-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, October 26, 2012 - 4:55 pm: |
|
Worked annai.. thanks for your help..
Siloan:
A Famous Quote starts with a... and ends with this.
|
Siloan
Pilla Bewarse
Username: Siloan
Post Number: 697
Registered: 09-2008
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, October 26, 2012 - 4:35 pm: |
|
Sasibabu:
 |
Sasibabu
Yavvanam Kaatesina Bewarse
Username: Sasibabu
Post Number: 9976
Registered: 10-2010
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, October 26, 2012 - 4:33 pm: |
|
Siloan:
maayyyaaa  |
Siloan
Pilla Bewarse
Username: Siloan
Post Number: 692
Registered: 09-2008
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, October 26, 2012 - 4:31 pm: |
|
Stewie:tried annai.. aina kuda ostaledu.. btw, I am trying to install in Server ..
annai...uninstall chesi reinstall cheyyi..
cheseptappud external security disable sesuko...or
If Windows Extended Security is enabled, you must add the domain account to the DB2ADMNS group or its equivalent.
nee personal server lo playing or haaffice ? |
Stewie
Kurra Bewarse
Username: Stewie
Post Number: 2731
Registered: 03-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, October 26, 2012 - 4:30 pm: |
|
Siloan:
tried annai.. aina kuda ostaledu.. btw, I am trying to install in Server ..
A Famous Quote starts with a... and ends with this.
|
Siloan
Pilla Bewarse
Username: Siloan
Post Number: 691
Registered: 09-2008
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, October 26, 2012 - 4:28 pm: |
|
SQL1092N
authorization-ID does not have the authority to perform the requested command or operation.
Explanation
Possible causes are as follows:
There was an attempt to execute a command or operation without having the appropriate authority for that command or operation.
In a Windows 2000 environment in which Kerberos authentication is being used, an attempt was made to log on to a computer with an account that is not a domain account.
In an LDAP environment, the user ID or the DB2 Connect gateway might not have the authority to perform the CATALOG DATABASE, CATALOG ... NODE, or CATALOG DCS DATABASE command.
In a Windows environment, the DB2 Server logon user ID, DB2_GRP_LOOKUP setting, and other group enumeration settings might not be configured properly, preventing the authorization ID authorization-ID from gaining access. A very common sample scenario follows:
An attempt is made to connect to the DB2 Server by using a domain user ID.
The logon user ID for the DB2 Server instance is LocalSystem or a local account.
Groups (SYSCTRL, SYSADM, SYSMAINT) are defined to be domain groups.
DB2_GRP_LOOKUP is not set. As a result, an attempt is made to enumerate the groups at the location where authorization-ID is defined. This fails because the DB2 Server instance is running under the context of LocalSystem or the local account and so cannot access the network resources required to enumerate the groups.
In a Windows environment with Extended Security enabled, the user ID authorization-ID might be attempting to use or modify a database resource, but the user ID is not a member of the local DB2USERS or DB2ADMNS group. This is not allowed. The command cannot be processed.
On Windows Vista or later versions of the Windows operating system, this command might be launched from a command prompt with only standard user privileges, even if the user is a local administrator. In this case, the command cannot be run because of insufficient administrative privileges.
The command cannot be processed.
Federated system users: The data source might have detected that the authorization ID does not have the authority to perform the requested command.
User response
Solutions to the problem causes are as follows:
Log on as a user with the correct authority and retry the failed command or operation. Contact your security administrator for assistance with adjusting your authorization. Refer to the Database Security Guide or search the DB2 Information Center for information about required authorization for the attempted command or operation.
Log on with a domain account.
Run the command UPDATE DBM CFG USING CATALOG_NOAUTH YES at the client or the gateway.
Make appropriate configuration settings changes. To fix the problem described in the scenario in the Explanation, change the logon user ID for the DB2 server instance to a domain account, and add this domain account to the local Administrators group. If Windows Extended Security is enabled, you must add the domain account to the DB2ADMNS group or its equivalent. For more information about Windows operating system security and groups, search the DB2 Information Center using phrases such as "DB2_GRP_LOOKUP" and "Windows authentication".
Add the user ID authorization-ID to the local Windows security groups DB2USERS or DB2ADMNS by using the Windows Computer Management tool. A workaround is to disable Extended Security but this may not be desirable because it reduces the level of security on your system.
Launch the command from a command window that is running with full administrative privileges. To do this, you can launch the "Command Window - Administrator" shortcut, and rerun the command.
Federated system users: If necessary, isolate the problem to the data source that is rejecting the request (see the Troubleshooting Guide for procedures to follow to identify the failing data source), and ensure that the authorization ID has the appropriate authority on that data source. |
Stewie
Kurra Bewarse
Username: Stewie
Post Number: 2729
Registered: 03-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, October 26, 2012 - 4:27 pm: |
|
Yea.. Windows 2008 Server
A Famous Quote starts with a... and ends with this.
|
Siloan
Pilla Bewarse
Username: Siloan
Post Number: 690
Registered: 09-2008
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, October 26, 2012 - 4:24 pm: |
|
windows? |
Stewie
Kurra Bewarse
Username: Stewie
Post Number: 2728
Registered: 03-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, October 26, 2012 - 4:19 pm: |
|
Unable to create a sample DB.. Giving error - SQL1092N.
Tried updating SYSADM_GROUP and SYSCTRL_GROUP to DB2ADMNS and user is domain account and is part of DB2ADMNS (this group was created while installation)
A Famous Quote starts with a... and ends with this.
|
Archives - 2012