DSXchange

Posted: **Sun Mar 15, 2020 5:31 pm**

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

Posted: **Mon Mar 16, 2020 9:27 am**

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.

DSXchange

Connecting SQL Server DB through Windows Authentication

Connecting SQL Server DB through Windows Authentication