SQL SERVER – Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publishe
Posted
by pinaldave
on SQL Authority
See other posts from SQL Authority
or by pinaldave
Published on Wed, 24 Mar 2010 01:30:39 +0000
Indexed on
2010/03/24
4:13 UTC
Read the original article
Hit count: 1833
Filed under:
Pinal Dave
|sql
|SQL Authority
|SQL Error Messages
|SQL Query
|SQL Scripts
|SQL Server
|SQL Tips and Tricks
|T SQL
|Technology
|SQL Replication
During configuring replication on one of the server, I received following error. This is very common error and the solution of the same is even simpler.
MSDTC on server is unavailable. Changed database context to publisherdatabase. (Microsoft SQL Server, Error: 8501)
Solution:
Enable “Distributed Transaction Coordinator” in SQL Server.
Method 1:
- Click on Start–>Control Panel->Administrative Tools->Services
- Select the service “Distributed Transaction Coordinator”
- Right on the service and choose “Start”
Method 2:
- Type services.msc in the run command box
- Select “Services” manager; Hit Enter
- Select the service “Distributed Transaction Coordinator”
- Right on the service and choose “Start”
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Filed under: Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology Tagged: SQL Replication
© SQL Authority or respective owner
