| Author |
Message
|
| arunk5151 |
 Posted: Fri Oct 04, 2013 1:19 am Post subject: Setting mqsisetdbparams with AD Id to connect to SQL server |
 |
|
Newbie
Joined: 04 Oct 2013
Posts: 3
|
Hi ,
I have a requirement of configuring the broker with AD id and password to connect to SQL datbase server .
The commands what I entered for setting up is given below :
a> First I created DSN
b> stopped the broker
c>executed :
mqsisetdbparams BROKERNAME -n SQL_ASDA_TMS -u UK\\sqltmsdb -p wmbdev
d>started the broker
after setting the above property and restarting the broker I tried to validate the connectivity using mqsicvp command which eventually failed and the error was logged in SQL server as
login failed for user 'UK\sqltmsdb' .Reason:Attempting to use an NT account name with SQL server authentication .
Note:
===
Broker is running on linux
The windows application is able to connect to SQL server using that AD Id
Broker is able to connect to SQL server using normal SQL id and password and failing with AD Id
Can somebody help me in telling whether whatever I am trying to implement is possible or not ?
If yes could you please help me what should I be doing to resolve this issue if I am missing something here ? |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Fri Oct 04, 2013 1:35 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| It's complaining that the DSN has a setting to use an SQLServer id. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Oct 04, 2013 1:43 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
In some DB ODBC connection configuration sections under windows you can choose between using OS auth or a DB user account for authentication.
As you are using Linux the ODBC definitition (in $ODBCINI) needs to be setup so that it uses the correct auth method.
_________________
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 |
|
|
| arunk5151 |
| Posted: Fri Oct 04, 2013 9:12 am Post subject: DSN details |
|
|
Newbie
Joined: 04 Oct 2013
Posts: 3
|
@mqjeff and smdavies99 : Yes I am using ODBC.INI file to add dsn entries and my dsn details are given below :
;# UNIX to SQLServer stanza
[SQL_ASDA_TMS]
Driver=/opt/IBM/mqsi/7.0/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 SQL Server Wire Protocol
Address=LABUKNTS5028.uk.wal-mart.com,14481
AnsiNPW=Yes
Database=TMS
Trusted_Connection=Yes
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
Can you please let me know if anything needs to be changed in this DSN in order to get this working ? |
|
| Back to top |
|
|
| arunk5151 |
| Posted: Sun Oct 06, 2013 6:57 pm Post subject: |
|
|
Newbie
Joined: 04 Oct 2013
Posts: 3
|
Can somebody please help on this issue ?  |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sun Oct 06, 2013 9:44 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Your last post is timed at 02:57 GMT/UTC on a monday Morning. There are very few people working at that time so getting any response is highly unlikely.
If you must have an immediate response then you have to raise a PMR and ask IBM for help. As toy are working on a project for ASDA (from your ODBC name) they should have a support contract in place so ... raise a PMR and get an answer. Don't forget to post the response here so that others can learn about it.
_________________
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 |
|
|
| alerajeshh |
| Posted: Mon Oct 07, 2013 11:52 am Post subject: |
|
|
Acolyte
Joined: 19 Aug 2013
Posts: 55
|
I think..he forgot to enter this command..
mqsisetdbparms Brokername -n odbc::DSN::default -u myuserid -p mypassword |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Oct 07, 2013 1:22 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| alerajeshh wrote: |
I think..he forgot to enter this command..
mqsisetdbparms Brokername -n odbc::DSN::default -u myuserid -p mypassword |
Then why in his original post did the OP quote:
| arunk5151 wrote: |
c>executed :
mqsisetdbparams BROKERNAME -n SQL_ASDA_TMS -u UK\\sqltmsdb -p wmbdev
|
Do you suspect a cunning plan to mislead us? Or did you not bother to read the post before offering this advice?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
