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
2. Expand Component Services | double Click Computers Node
3. Right Click | MyComputer | Select Properties
4. Select MSDTC Tab | Select Security Configuration
5.Check Network DTC Access check box.
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
Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook
