Showing posts with label RPC ERROR. Show all posts
Showing posts with label RPC ERROR. Show all posts

20 November 2011

Solution for MSDTC Error While Submit Account of Point of Sale in SQL 2008 R2



  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 <instancename> 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, click OK.
    A message box asks whether you want to restart the SQL Server service.
  6. Click Yes, and then close SQL Server Configuration Manager.

10 February 2011

WHEN COMING RPC ERROR

WHEN ERROR COMING RPC DURING SUBMITTING OF POINT OF SALE ACCOUNT
RUN THIS BELOW QUERY IN QUERY ANALYZER USE TREASURY DATA BASE
After many days of implementation of Meghdoot Enhancement many of our friends facing  problems. So I have decided to post the solutions again.

1) While doing submit accounts ‘Server not configured for RPC’
Solution: Run the following query using query analyzer (replace ‘server’ with your server name):

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

Note: The above error is related to SQL Server configuration settings and not related to the application. (RPC is Remote Procedure Call).