>I am facing the following problem. Please reply it as soon as possible.
>
>
> Error:-2147217900 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction
>
>
>
> Situation: Server A & Server B are connected through Linked Server.
>
>
> the above error occurs in step 3
>
> Step1: Start a Transaction in VB Code in Server A.
> Step2: Fire a Update statement in the local database of Server A.
> step3: Execute a stored procedure of Server B.
> Step4: Commit the Transaction in VB Code in server A.
> After that, above error is coming.
Amit,
MS DTC is not configure for network access.
1. Click Start, point to All Programs, point to Administrative Tools, and then click Component Services.
2. In the Component Services Wizard, expand Component Services, and then double-click Computers.
3. Right-click My Computer, and then click Properties.
4. Click the MS DTC tab, and then click Security Configuration.
5. In the Security Configuration dialog box, click to select the Network DTC Access check box.
6. Under Network DTC Access, click Network Transactions.
Note If you installed Service Pack 1 for Windows Server 2003, you can click Allow Inbound and Allow Outbound.
7. Make sure that DTC Logon Account is set to NT Authority\NetworkService.
8. Click OK.
9. In the message box, click Yes to continue.
10. In the DTC Console Message dialog box, click OK.
11. In the System Properties dialog box, click OK.
12. Reboot the computer for these changes to take effect.
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º°`°º¤ø¤º°¤º°
Carl Evans
CEO & President
System Answers Consulting, Inc.
MCSD .NET, ASP.NET, C#.NET, VB.NET,