| Author |
Message
|
| madiba |
 Posted: Wed Dec 28, 2005 9:11 pm Post subject: DB2 security issue |
 |
|
Novice
Joined: 14 Oct 2005
Posts: 23
|
I installed message broker version 6 for Windows and am trying to do the default configuration. However this part fails and according to the logs it fails when trying to create the default broker becaue the user does not have authorization to perform the task. I looked at the security setting for the user ID and it does belong to the Administrator and the mqbrkrs group. The error reads as follows:
"SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID")."
Please advise. |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Wed Dec 28, 2005 9:21 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Why dont you use the command from the command line....
This way you can first create the database, its DSN and then create the broker....
By the way what user id have you logged in with ??
Why dont you simply try to create a databse with the same userid and check, if it fails then you know its not MB's fault.
Regards. |
|
| Back to top |
|
|
| madiba |
| Posted: Thu Dec 29, 2005 6:05 am Post subject: |
|
|
Novice
Joined: 14 Oct 2005
Posts: 23
|
| The user id I am using is the same one I used when I installed MB i.e. its not the dbadmin user. Do I need to use the dbadmin user id to create the broker? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Dec 29, 2005 6:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You need to create the database first, in the DB2 control center.
Then you need to grant DB2 authorizations to the broker service user for the databse in the DB2 Control Center.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Dec 29, 2005 8:12 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi madiba,
I hope your userId id a member of the Administrators and that db2 is a menber of Administrators too.....You could further add the db2 as a member of your id itself.
Create the database while being logged in as your current userId and not db2admin.
Once it is successfully created, use the mqsicreate to create broker.
Regards. |
|
| Back to top |
|
|
| premkumar |
| Posted: Sun Jan 01, 2006 11:51 pm Post subject: |
|
|
Apprentice
Joined: 24 Feb 2004
Posts: 40
|
Hi madiba,
Make sure the Broker database is created with the userid used for WBIMB. This will make sure the default schema for the broker db and the broker user id are same.
u can check by connecting to the database with the user id and password
db2==> connect to <brokerdb> user <WBIMB user> using <WBIMB user password>
If you are able to connect then u will be able to create broker.
_________________
Thanks and Regards,
Premkumar.S |
|
| Back to top |
|
|
|
|
