Post AD Migration Issues And Solution

(AV=Anti Virus and AD=Active Directory.  This is a process by which all the systems in post offices will be migrated to India Post domain.  Your office SA and AP Online Mandal Co-ordinator(on behalf of TCS) will attend all Post Offices to install AV & AD)

At the time of AD Migration we have to change the SQL Server Name. So that we have to configure server name in all the DOP Softwares and SQL Server.

Issues 1

·         RPC error while Submit Point of Sale account.

·         MSDTC Services not running

Solution

·         Go to Services (Control Panel > Administrative Tools >Services) / Run > Services.msc

·         Start the service 'Distributed Transaction Coordinator' (MSDTC) with start up type as 'Automatic' and Log On As 'Network Service' 

Execute RPC Query at Once

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.

Download Tool

Issues 2

POS booked articles not fetching in speed net module after changing the server name or formatting the server in SQL 2005 / 2008

Solution 1 : 

Run these two queries in SQL query analyzer one by one

sp_configure 'show advanced options',1
go
reconfigure

Then Execute

sp_configure 'Ad Hoc Distributed Queries',1
go
reconfigure

Solution 2

Right click on server name in SQL management studio->facets-> surface area configuration.

Set true to Ad hoc remote queries.

Courtesy: http://potools.blogspot.in/