Error Message like " MSDTC SERVICES IS NOT RUNNING "

Go to Services (Control Panel-- Administrative Tools--Services ) and then start the service 'Distributed Transaction Coordinator' (MSDTC) with start up type as 'Automatic' and Log On As 'Network Service' as shown in the attachment. Then execute the Query relating to 'RPC' error to solve the problem.

Run the following query using query analyzer (replace ‘myserver’ with your server name):

exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'
go
exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'
go