Thursday, August 29, 2013

RPC error query

Problem : After instollation SQL Express and M.M.7.0 


1. RPC errore while submitting  POS Submit account 
2. Error Message like " MSDTC SERVICES IS NOT RUNNING "


Solution :
1.

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


Note:  Replace 'myserver' with your servername in the above query.




2. 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 below mentioned Query relating to 'RPC' error to solve the problem.

No comments:

Post a Comment