Connecting SQL Server DB through Windows Authentication
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
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