Sunday 13 November 2011

MSDTC Services not running error in Submit Account of Point of Sale.

Solution:
1.On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.
2.In SQL Server Configuration Manager, click SQL Server Services.
3.In the details pane, right-click the name of the SQL Server instance for which you want to change the service startup account, and then click Properties.
4.In the SQL Server Properties dialog box, click the Log On tab, chose Built in Account and select Local System as account type.
5.After selecting the new service startup account(i.e Local System), click OK.
6.A message box asks whether you want to restart the SQL Server service.
7.Click Yes, and then close SQL Server Configuration Manager.

After that sometimes RPC error may occurs at the time of submit account. Execute following query by replacing your server name in the place of MyServername.
exec sp_serveroption @server=' MyServername ', @optname='rpc', @optvalue='true'
go
exec sp_serveroption @server=' MyServername ', @optname='rpc out', @optvalue='true'
go

0 comments:

Post a Comment