| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ODBC Connection using Windows authentication |
« View previous topic :: View next topic » |
| Author |
Message
|
| shwe |
 Posted: Fri Dec 28, 2012 4:05 am Post subject: ODBC Connection using Windows authentication |
 |
|
Novice
Joined: 28 Dec 2012
Posts: 13
|
Hi All,
We are using Message broker 6.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:
(
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbComputeNode.cpp'
(0x03000000):Line = 464
(0x03000000):Function = 'ImbComputeNode::evaluate'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'com/pwc/dms/gfs/legalclient/DMSGFSLegalClientExtract#FCMComposite_1_4'
(0x03000000):Label = 'com.pwc.dms.gfs.legalclient.DMSGFSLegalClientExtract.GFS Extract'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Caught exception and rethrowing'
(0x01000000):DatabaseException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x03000000):Line = 227
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2321
(0x03000000):Text = 'Root SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '-1'
)
(0x01000000):DatabaseException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x03000000):Line = 355
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2322
(0x03000000):Text = 'Child SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '28000'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '18452'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.'
)
)
(0x01000000):DatabaseException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x03000000):Line = 355
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2322
(0x03000000):Text = 'Child SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'IM006'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '0'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed'
)
)
)
)
)
Please let me know if its possible to connect ODBC to Broker using windows authentication mode and what would be the required level of permission. |
|
| Back to top |
|
 |
| exerk |
| Posted: Fri Dec 28, 2012 5:15 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Moved to a more appropriate forum...
shwe, please take more care in choosing the forum you post in. Thank you.
_________________
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 |
|
|
| lancelotlinc |
| Posted: Fri Dec 28, 2012 6:03 am Post subject: Re: ODBC Connection using Windows authentication |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| shwe wrote: |
| We are using Message broker 6.0 |
Upgrade to a supported version, then repost the problem if you still have one. WMB V6 has been end of life for quite some time.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| shwe |
| Posted: Fri Dec 28, 2012 7:12 am Post subject: |
|
|
Novice
Joined: 28 Dec 2012
Posts: 13
|
| Our company has got support extended for v6 from IBM and is in no plans of upgrading it currently, but till then, this issue needs a fix. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Dec 28, 2012 7:14 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| shwe wrote: |
| Our company has got support extended for v6 from IBM and is in no plans of upgrading it currently, but till then, this issue needs a fix. |
Then open a PMR using your extended support agreement. There has been hundreds of ODBC-related bug fixes between V6 and V8.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| 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
|
|
|
|
