MQSeries.net :: View topic - Unable to connect to Datasouce : login failed for user 'loca

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Unable to connect to Datasouce : login failed for user 'loca

Unable to connect to Datasouce : login failed for user 'loca

« View previous topic :: View next topic »

Author

Message

sasad

Posted: Sun Sep 14, 2014 11:40 pm Post subject: Unable to connect to Datasouce : login failed for user 'loca

Acolyte

Joined: 30 Apr 2014
Posts: 67

I need to connect to Database from IIB. I have created following msg flow,

MQInput -> Compute -> MQOutput

I followed following steps,

1. Created ODBC connection on my OS.
2. Create a property for DSN using following command
mqsisetdbparms IB9NODE -n dsn::DSNName -u username -p password

3. Verified this dsn using cvp command
mqsicvp IB9NODE -n DSNName

4. It successfully executes.

But when I try to execute my msg flow I get following exception
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'LocalSystem'.

I don't understand why it is trying to connect using user 'LocalSystem'.

Please help!!

fjb_saper

Posted: Mon Sep 15, 2014 4:14 am Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20696
Location: LI,NY

have you tried executing the command without the dsn:: ?
What was the result then?
Do you have a system dsn configured?

Looks to me like you are going beyond the usual scope and have defined a microsoft active directory login for the SQL server. This should really be a SQL Server user login which ever way you define those...

Have fun

_________________
MQ & Broker admin

sasad

Posted: Fri Sep 19, 2014 4:08 am Post subject:

Acolyte

Joined: 30 Apr 2014
Posts: 67

I was able to resolve this issue by executing the command without prefix dsn::

But I don't understand what is the problem with prefix. There are two database. I created System DSN for both. Both ODBC are successfully connecting to DBs. Then I configured connnection on broker with prefix dsn::

I am able to connect first db with dsn:: prefix, but unable to connect to other db.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Unable to connect to Datasouce : login failed for user 'loca

Jump to:

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

Protected by Anti-Spam ACP