MSDTC on server ‘PC-Name’ is unavailable.

Hello friends, We have already explained you regarding STUFF and CONCAT in SQL, RANK(), DENSE_RANK(), ROW_NUMBER() , Aggregate functions in sql server and Identity column in sql server.Sometime we are getting below error, while we are configuring Replication.

To resolve this error we have to follow below steps:
1. Click on Start–>Control Panel->Administrative Tools->Services
2. Select the service “Distributed Transaction Coordinator”
3. Right click on the service and choose “Start”

We can also directly go on second step by going Run and type “services.msc”.