I am new to the forum and to WebSphere Message Broker. What I need to do is create a service that reads/writes stuff from/to a database that is accessed via ODBC. Service itself works fine (is invokable).
I have created a local ODBC connection 'SQL_DB' with NT authentication. This form of authentication is a must due to policy where I work. Now I added the connection to the broker using the mqsi console with
mqsisetdbparms MB7BROKER -n SQL_DB -u dummy -p dummy
Reason for 'dummy' is that, again, NT authentication is desired. Result message says its fine. If I test this with
mqsicvp MB7BROKER -n SQL_DB
everything works fine, I get something like (freely translated from German) 'Connected with data source SQL_DB ... ' and my NT credentials, as desired. Now I set this connection name as data source in my message flow. Accessing the message flow returns error
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON
to the service. I get this no matter if I actually try to access the DB, just from specifying the data source in the flow and invoking it via service call.
To you experts out there, why does the mqsicvp test succeed but the usage in the flow fails?
- MB is version 7
- OS is XP (please don't sigh)
- DB is SQL Server, driver version is 3.85.1132
Any help appreciated.