| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database access thru compute node |
« View previous topic :: View next topic » |
| Author |
Message
|
| rkford11 |
 Posted: Mon Nov 15, 2004 1:51 pm Post subject: Database access thru compute node |
 |
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
Hi,
I'm trying to access a a database, but i'm getting this error
"[IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason 24 ("USERID and/or PASSWORD INVALID"). SQLSTATE=08001"
I'm using WBIMB on Windows 2000. I create a ODBC connection with the DB2 driver and the test was sucessful. In my message flow, name of the ODBC source created. This message flow only have a mqinput a compute node and mqoutput .
My broker run as windows service using the user that have permissions to access the database (used when creating the ODBC).
The broker and configmgr databases are on one system and the database i am trying to access is on the other system.
Can somebody help me with this problem and let me know where i am making the mistake
Thanks. |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Nov 15, 2004 2:06 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
What version of WMQI are you using? What is the command you used to create the broker?
In WMQI 2.1, if you specify -u & -p parameters in mqsicreatebroker command then this user-id will be used by the broker when interacting to any of the DB (internal or external). If you don't specify these parameters then Broker will use it's service user-id and pwd to access DB.
In WBIMB 5.0, you can issue mqsisetdbparms command to set user-id/pwd for each DSN.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| rkford11 |
| Posted: Mon Nov 15, 2004 4:37 pm Post subject: |
|
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
| kirani wrote: |
What version of WMQI are you using? What is the command you used to create the broker?
In WMQI 2.1, if you specify -u & -p parameters in mqsicreatebroker command then this user-id will be used by the broker when interacting to any of the DB (internal or external). If you don't specify these parameters then Broker will use it's service user-id and pwd to access DB.
In WBIMB 5.0, you can issue mqsisetdbparms command to set user-id/pwd for each DSN. |
Thanks Kiran,
With u r suggestion i made the flow work. I am working on WBIMB 5.0. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
