Hello Shivanga,
Do you how I can use Windows Authentication?
I tried ODBC connection and I checked "Use DSN", but it doesn't work too.
Thanks
Federico
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.
Regards,
Nico
Hi Federico,
The last comment by Shivanga is true.
Please let us know if this issue is pending or is resolved.
Thanks,
Harish
Hi Harish
yes it's.
DBA's team created me a sql authentication...
This is not the solution I wanted...
Thanks a lot
Federico