We have a requirement to connect to the SQL server using Windows Authentication . Till now we have connected to the same server using odbc connectivity and a database user has been created specifically for our project and the same has been defined in SAS Authdomain and we are able to connect to the database.
As I said, now we have to connect using WIndows authentication mode. SQL Server and SAS Server are in the same domain and my ID has been added to the domain and the privilege's for my ID has been provided in the SQL server. I have configured the odbc.ini file as 'trusted connection = yes' . But still I'm not able to connect to the SQL server.
Is there any other option I have to use in odbc.ini file to connect for Windows authentication?? Thanks in Advance.