SQL Server - Win NT Authentication

ejazsalim · Post by **ejazsalim** » Sat Aug 28, 2010 3:32 am

Is it possible to logon to a SQL Server DB using Windows Authentication this is what I have in my .odbc.ini and it doesn't work

[MARS08062010]
Driver=/opt/is/IBM/InformationServer/Server/branded_odbc/lib/VMmsss23.so
Description=DataDirect SQL Server Wire Protocol driver
Database=MARS08062010
LogonID=
Password=
Address=wassql001v,1433
QuotedId=No
AnsiNPW=No

Sreenivasulu · Post by **Sreenivasulu** » Sat Aug 28, 2010 5:35 am

Login datastage -
When you install datastage you can opt to LDAP authentication OR providing the userid/pwd seperately.
Login sqlserver - A similar feature for database access which you referred would be great. Maybe the experts may know the answer

Regards
Sreeni

chulett · Post by **chulett** » Sat Aug 28, 2010 7:56 am

Your ODBC entry wouldn't control that part as far as I know, that would have to be an option in the actual stage you are using to connect. I've done this in Oracle via their native stages, no clue if you can do the same for SQL Server however.