| Author |
Message
|
| syed |
 Posted: Sat Dec 29, 2012 11:24 pm Post subject: ODBC Connection |
 |
|
Newbie
Joined: 29 Dec 2012
Posts: 1
|
Hi All,
We are using Message broker 7.0, we have a requirement to connect to a SQL server 2008 R2 using windows authentication mode.
We have created a domain account and ODBC connection using the domain account, the ODBC test is successful. However, when we trigger the message flow, it throws the below error
EXCEPTION: -> MESSAGE FAILED DUE TO THE FOLLOWING EXCEPTION:
Replay what i con do ASAP..
thanks for the same... |
|
| Back to top |
|
 |
| exerk |
| Posted: Sun Dec 30, 2012 3:41 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Moved to a more appropriate forum...
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sun Dec 30, 2012 6:43 am Post subject: Re: ODBC Connection |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| syed wrote: |
Hi All,
EXCEPTION: -> MESSAGE FAILED DUE TO THE FOLLOWING EXCEPTION:
|
There is a LOT more to an exception than the little bit you quoted.
What do the entries in the Windows Event Log say?
We really do need a lot more information before we can provide much (if anything in the way of) help and assistance.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| visasimbu |
| Posted: Sun Dec 30, 2012 7:09 am Post subject: Re: ODBC Connection |
|
|
Disciple
Joined: 06 Nov 2009
Posts: 171
|
| syed wrote: |
We are using Message broker 7.0, we have a requirement to connect to a SQL server 2008 R2 using windows authentication mode.
EXCEPTION: -> MESSAGE FAILED DUE TO THE FOLLOWING EXCEPTION:
Replay what i con do ASAP..
|
What you have tried in esql to access the database ?
Did you run the mqsisetdbparams cmd?
Did you created the DSN ?
Post your Trace log, it will be used to narrow down the issue. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Sun Dec 30, 2012 8:04 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Are you running Broker on Windows? |
|
| Back to top |
|
|
|
|
