Do you how I can use Windows Authentication?
I tried ODBC connection and I checked "Use DSN", but it doesn't work too.
I fear that - as Harish has pointed out - you cannot use Windows AD authentication in this case if that user is NOT the same user ID as the one running the Windows service Informatica10.1 (or whatever version you have). No chance.
In other words: Windows authentication only for the Windows service user; otherwise you have to set up a SQL Server user.
Harish, please correct me if I'm mistaken here.
The last comment by Shivanga is true.
Please let us know if this issue is pending or is resolved.
DBA's team created me a sql authentication...
This is not the solution I wanted...
Thanks a lot