Error 8501

Troubleshooting SQL Server

Troubleshooting

Error 8501

Severity Level 16
Message Text

MS DTC on server '%.*ls' is unavailable.

Explanation

This error can occur while processing an INSERT, UPDATE, or DELETE statement inside an explicit or implicit transaction. This error typically indicates that the MSDTC service is not running on the local server. Data modification statements in an explicit or implicit transaction require the MSDTC service to be running and the provider's support of distributed transactions.

Action

Use SQL Server Service Manager to verify that the MSDTC service has been started on the server. For more information, see the Microsoft Distributed Transaction Coordinator documentation.

See Also

Distributed Queries

Errors 7000 - 7999