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
Connecting SQL Server DB through Windows Authentication
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 104
- Joined: Thu Jul 12, 2007 11:32 pm
- Location: Canada
Connecting SQL Server DB through Windows Authentication
Thanks
Aditya Kutcharlapati
Aditya Kutcharlapati
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.
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.
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
Choose a job you love, and you will never have to work a day in your life. - Confucius