SQL SERVER – Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase

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)

SQL SERVER - Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase msdtc1

Solution:

Enable “Distributed Transaction Coordinator” in SQL Server.

Method 1:

  1. Click on Start–>Control Panel->Administrative Tools->Services
  2. Select the service “Distributed Transaction Coordinator”
  3. Right on the service and choose “Start”

Method 2:

  1. Type services.msc in the run command box
  2. Select “Services” manager; Hit Enter
  3. Select the service “Distributed Transaction Coordinator”
  4. Right on the service and choose “Start”

SQL SERVER - Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase msdtc2

SQL SERVER - Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase msdtc4

Reference : Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQLAuthority News – We’re sorry… … but your computer or network may be sending automated queries. To protect our users, we can’t process your request right now.
Next Post
SQL SERVER – Generate Report for Index Physical Statistics – SSMS

Related Posts

24 Comments. Leave new

Leave a Reply

Menu