Connecting SQL Server DB through Windows Authentication

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
adityavarma
Premium Member
Premium Member
Posts: 104
Joined: Thu Jul 12, 2007 11:32 pm
Location: Canada

Connecting SQL Server DB through Windows Authentication

Post by adityavarma »

Hello DS gurus,

I am trying to connect the SQL Server through windows authentication.

I have included the below entry in the .odbc.ini file

[ODBC_SQL]
Driver=/home/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss00.so
Description=DataDirect SQL Server Wire Protocol driver
Database=<Database_name>
AuthenticationMethod=9
LogonID_LEN=52
Password_LEN=52
LogonID=********
Password=*******
Address=<Provided the server name here>, <Port_number>
Domain=<Provided the Domain Name>
QuotedId=No
AnsiNPW=No


I am providing the correct credentials but still the below error is thrown.

Issue:
[28000][unixODBC][IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver][SQL Server]Login failed for user ''.
[ISQL]ERROR: Could not SQLConnect

Can you please let me know if i have to include any other details or if i am missing anything
Thanks
Aditya Kutcharlapati
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Not sure why. Have you verified outside of this tool if the same credential connects OK using SQL Server Management Studio?

Ours works but I am using a different driver (VMsqls00.so). Just for kicks, can you try one with this driver? Below is the entire driver entry; no other properties are required.

Code: Select all

[xxxx]
Driver=/xxxxxxxxxxxxxxxxxxxx/branded_odbc/lib/VMsqls00.so
Description=DataDirect SQL Server Native Wire Protocol
AuthenticationMethod=9
Database=xxxx
Domain=xxxx
HostName=xxxx
PortNumber=xxxx
Apart from that, unusual connection problems can be caused by certain special characters within your password, so that would be my next guess as to where to look.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply