| Author |
Message
|
| chandu603 |
 Posted: Mon Oct 21, 2013 8:05 am Post subject: [IBM][ODBC SQL Server Driver][SQL Server]Login failed for us |
 |
|
Newbie
Joined: 21 Oct 2013
Posts: 4
|
Hi,
I am trying to connect to SQL server from Websphere Message Broker running on AIX m/c. I am using the ODBC driver configured in odbc.ini file.
My windows domain user is created on SQL Server.
I ran the mqsisetdbparms with the domain user credentials.
I am getting the below error whenever I am trying to connect.
[IBM][ODBC SQL Server Driver][SQL Server]Login failed for user <domainUser>.
Is it possible to connect to SQL server using windows authentication from Broker on AIX m/c using ODBC.
The same is working if I am connecting from Java standalone program which is running on windows system by using integrated security (windows authentication).
Please let me know how to connect to SQL server using windows authentication from Broker on AIX m/c using ODBC. |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Mon Oct 21, 2013 8:27 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
This has been covered a few times here.
Do a search for
| Code: |
[IBM][ODBC SQL Server Driver][SQL Server]Login failed for user
|
_________________
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 |
|
|
| chandu603 |
| Posted: Mon Oct 21, 2013 11:07 am Post subject: [IBM][ODBC SQL Server Driver][SQL Server]Login failed for us |
|
|
Newbie
Joined: 21 Oct 2013
Posts: 4
|
Hi,
I searched but it looks like no one answered "how to connect to SQL server using windows authentication from Broker on AIX m/c using ODBC"
It will be great help if you give me the answer.
Some more info:
1)Even I tried with below command and I am getting the same error
mqsicvp –n MyDB –u domain\\username –p password
2) If I am using the same credentials in my Java program I am able to connect. |
|
| Back to top |
|
|
| nukalas2010 |
| Posted: Mon Oct 21, 2013 11:11 pm Post subject: |
|
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
| set the username and password using mqsisetdbparms, restart broker and check connectivity using mqsicvp command. |
|
| Back to top |
|
|
| dogorsy |
| Posted: Tue Oct 22, 2013 12:02 am Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
if I remember well, when you define the ODBC system DSN for a SQLServer database you have the option of specifying userid and password OR use windows authentication. But if your broker is running on AIX, how would it use windows authentication ?!!  |
|
| Back to top |
|
|
| chandu603 |
| Posted: Tue Oct 22, 2013 2:25 am Post subject: [IBM][ODBC SQL Server Driver][SQL Server]Login failed for us |
|
|
Newbie
Joined: 21 Oct 2013
Posts: 4
|
Hi,
Even I thought the same "But if your broker is running on AIX, how would it use windows authentication".
If the above is not possible then I can ask DBA to create a SQL Server User.
which we can provide through mqsisetdbparms.
Please let me know if there is any other way to connect. ("But if your broker is running on AIX, how would it use windows authentication".) |
|
| Back to top |
|
|
| dogorsy |
| Posted: Tue Oct 22, 2013 2:29 am Post subject: Re: [IBM][ODBC SQL Server Driver][SQL Server]Login failed fo |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| chandu603 wrote: |
Please let me know if there is any other way to connect. ("But if your broker is running on AIX, how would it use windows authentication".) |
you need to read the documentation. It is clearly explained how to set up odbc connections for each supported database. |
|
| Back to top |
|
|
| chandu603 |
| Posted: Tue Oct 22, 2013 3:37 am Post subject: [IBM][ODBC SQL Server Driver][SQL Server]Login failed for us |
|
|
Newbie
Joined: 21 Oct 2013
Posts: 4
|
Hi,
Here my question is whether it is possible to use windows authentication on AIX OR not possible at all?
If possible give me the pointer.
I know how to setup ODBC in normal scenarios and it is working also.(for other databases) |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Oct 22, 2013 3:57 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
If you want an official answer then you will need to raise a PMR and ask IBM or partake in the session that is advertised in the first post at the top of this forum.
Where I have faced this sort of problem in the past, the AD managers insisted that EVERY account had a password expiry of no more than 60 days. So we just created local accounts(unix) and SQLServer specific accnt and bypassed their foolishness. Naturally we had the blessing of the Security folks. So we never even had to try to connect like this.
_________________
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 |
|
|
|
|
