Apr 6, 2010

AcquireConnection error in SSIS(Remotly)

1. Click Start, click Control Panel, click Administrative Tools, and then click Component Services. Expand Component Services, and then expand Computers.

2. Right-click My Computer, and then click Properties.

3. Click the MSDTC tab, and then click Security Configuration.

4. Make sure that the following check boxes are selected:

• Network DTC Access

• Allow Remote Clients

• Allow Remote Administration

• Allow Inbound

• Allow Outbound

• No Authentication Required

5. Make sure that the DTC Logon Account is set to NT AUTHORITY\NetworkService.

6. Add MSDTC.exe as an exception in Windows Firewall.