Wednesday, March 28, 2012

Informatica Connecting to SQL Server

Hello. Can Informatica use an NT account to connect to SQL
Server, for purposes of using the Informatica repository
and any transaformations, etc...? I'd rather not create a
SQL logon for the ETL folk, but use an NT account.
THey're having an issue connecting with an NT account from
Informatica. Any ideas' THanks, BRuceYou should be able to map the NT accounts in with no problem.
Are you sure of the following:
1. Informatica is using that NT account to attempt to access SQL Server?
2. Is the NT account a member of the domain in which your SQL Server lives?
If not, is it a member of a trusted domain?
Rick Sawtell
MCT, MCSD, MCDBA
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:0ebc01c47b23$78497b90$a601280a@.phx.gbl...
> Hello. Can Informatica use an NT account to connect to SQL
> Server, for purposes of using the Informatica repository
> and any transaformations, etc...? I'd rather not create a
> SQL logon for the ETL folk, but use an NT account.
> THey're having an issue connecting with an NT account from
> Informatica. Any ideas' THanks, BRuce

No comments:

Post a Comment