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, BRuce
You 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
sql

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

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

Infopath

I am using SBS 2003 Premium with SQL Server installed and
updated to SP3a. When I connect to the example database
in infopath 2003 the "Submit to database" option is there
when I insert a submit button. When I created my own
database, the option is not there. Any ideas?
Thanks
I remember running into this issue a couple of months ago when I was
struggling to learn Infopath, but I forgot what the answer is -- it
has to do with Infopath, not SQL Server. I'd post on the
microsoft.public.infopath newsgroup, where you're more likely to get
responses from people who use Infopath regularly :-)
--Mary
On Wed, 12 May 2004 07:30:47 -0700, "Brent Goff"
<brentgoff@.goffcom.net> wrote:

>I am using SBS 2003 Premium with SQL Server installed and
>updated to SP3a. When I connect to the example database
>in infopath 2003 the "Submit to database" option is there
>when I insert a submit button. When I created my own
>database, the option is not there. Any ideas?
>Thanks

Infameous 0x80070005 ERROR: Access denied

Hi, my name is Beatriz and I'm another victim of the 0x80070005 from
Hell. I'm running WBEMTEST from a PC to connect to another one with WXP
SP2 and even:

1. The firewall is down.
2. Applied the commands:
netsh firewall set service RemoteAdmin enable
netsh firewall add portopening protocol=tcp port=135 name=DCOM_TCP135
3. Did the workaround suggested in:
http://support.microsoft.com/kb/909444
4. Ran the workaround in: http://support.microsoft.com/kb/884573
5. Added the account I use to access by Wbemtest with to the Default
Lauch Permissions with Full Control.
6. Checked up the registry
:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\forceguest
were set to 0.

I keep not being able to connect, and receving 0x80070005, what I'm
missing?!?!?!?Are you looking for SQL Server Integration Services help?|||

Did you ever get a response or resolution to this?

Hopefully, your system isn't still DOA 7-8 months later.

We have exactly the same issue with a brand-new server running WinServer 2003x64 R2

Have installed/reinstalled the entire OS three times now. The solution I guess is to do yet another reinstall and then not install the rogue security patch but that would leave us vulnerable to whatever the security patch was trying to fix and who knows what future M/Soft update won't do something similar?

|||Are you having SSIS problems when trying to connect to the SSIS service via Management Studio?

http://www.ssistalk.com/2007/04/13/ssis-access-is-denied-when-connection-to-remote-ssis-service/

Infameous 0x80070005 ERROR: Access denied

Hi, my name is Beatriz and I'm another victim of the 0x80070005 from
Hell. I'm running WBEMTEST from a PC to connect to another one with WXP
SP2 and even:

1. The firewall is down.
2. Applied the commands:
netsh firewall set service RemoteAdmin enable
netsh firewall add portopening protocol=tcp port=135 name=DCOM_TCP135
3. Did the workaround suggested in:
http://support.microsoft.com/kb/909444
4. Ran the workaround in: http://support.microsoft.com/kb/884573
5. Added the account I use to access by Wbemtest with to the Default
Lauch Permissions with Full Control.
6. Checked up the registry
:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\forceguest
were set to 0.

I keep not being able to connect, and receving 0x80070005, what I'm
missing?!?!?!?Are you looking for SQL Server Integration Services help?|||

Did you ever get a response or resolution to this?

Hopefully, your system isn't still DOA 7-8 months later.

We have exactly the same issue with a brand-new server running WinServer 2003x64 R2

Have installed/reinstalled the entire OS three times now. The solution I guess is to do yet another reinstall and then not install the rogue security patch but that would leave us vulnerable to whatever the security patch was trying to fix and who knows what future M/Soft update won't do something similar?

|||Are you having SSIS problems when trying to connect to the SSIS service via Management Studio?

http://www.ssistalk.com/2007/04/13/ssis-access-is-denied-when-connection-to-remote-ssis-service/