The error msg 7391 level 16 state 1 line 1 says

“Msg 7391, Level 16, State 2, Line 1

The operation could not be performed because OLE DB provider “SQLNCLI” for linked server XXX was unable to begin a distributed transaction”

A common cause for this problem is that Microsoft Distributed Transaction Coordinator isn’t configured for network access. The MSDTC network access settings are disable default for new SQL Server 2000 installation on Windows Server 2003.

To resolve this enable MSDTC network access settings as shown below.

1. Open component services: START | All Programs | Administrative Tools | Component Services

1_msg 7391 level 16 state 1 line 1 in sql server

2. Expand Component Services | double Click Computers Node

3. Right Click | MyComputer | Select Properties

4. Select MSDTC Tab | Select Security Configuration

2_msg 7391 level 16 state 1 line 1 in sql server

5.Check Network DTC Access check box.

3_msg 7391 level 16 state 1 line 1 in sql server

If above fix doesn’t works for you then try this http://support.microsoft.com/kb/250367/

If above fix doesn’t works try this http://support2.microsoft.com/kb/899607

 

Regards

Ahmad Osama

Like us on FaceBook Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook