SQL Server connection with AD user

1 2 Previous Next 18 Replies Latest reply on Mar 30, 2020 1:05 AM by Federico Fanalista Go to original post

15. Re: SQL Server connection with AD user

Federico Fanalista Mar 5, 2020 6:07 AM (in response to Shivanga Srinivas Bandaru)

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
Like Show 0 Likes(0)

Actions
16. Re: SQL Server connection with AD user

Nico Heinze Mar 5, 2020 9:19 AM (in response to Federico Fanalista)

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
Like Show 0 Likes(0)

Actions
17. Re: SQL Server connection with AD user

Harish Kumar Dola Mar 29, 2020 11:52 PM (in response to Federico Fanalista)

Hi Federico,

The last comment by Shivanga is true.
Please let us know if this issue is pending or is resolved.

Thanks,
Harish
Like Show 0 Likes(0)

Actions
18. Re: SQL Server connection with AD user

Federico Fanalista Mar 30, 2020 1:05 AM (in response to Harish Kumar Dola)

Hi Harish
yes it's.
DBA's team created me a sql authentication...
This is not the solution I wanted...

Thanks a lot
Federico
Like Show 0 Likes(0)

Actions

1 2 Previous Next

Signing in to Informatica Network