May 5, 2015

Post AD Migration Issues and Solution

Post AD Migration Issues and Solution

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.

---------------------------------------------------------------------------------

Issues 2

POS booked articles not fetching in speednet 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.

No comments:
Write comments

Labels

.Net setup (6) Aadhaar Card (150) Aadhar Software (38) Accounts (24) Active Directory (10) AD Rollout (12) Advertisement (21) Adware Removal Tool (6) Agent Portal (18) Agent software (6) All in One Drivers (5) Allowance (337) Android (55) android indiapost (35) Annual Property Returns (11) Anomalies in 7th CPC (46) Answer Key (38) antivirus (37) Application Form (10) Army Postal Service (16) Atal Pension Yojana (48) Bank News (35) Bhuvan India Post (6) BNPL (25) BNPL Bill Generation (6) BO Account verification Tool (2) BO Finacle (11) BO Mapping (1) BO Rules (2) BO Slip (5) Bonus News (73) Bonus Order (36) BPM (17) branch office (26) Cadre Restructuring (117) Cadre Review (70) CAT Case (37) CAT Judgement (17) Central Government Employees (322) Circular and Orders (74) Clarification (128) Collection of SB Orders (42) Commemorative Stamps (41) Compassionate Cases (37) Court Case (28) CPC Software (4) DA News (171) DA orders (48) DARPAN (39) Data Profiling Tool (38) Database Backup Tool (4) DB Tools (8) DBAnalyzer (69) Department of Posts (340) Departmental Examination (109) Deputation (37) despatch error & Solution (31) Dharna Programme (44) Directorate (100) Directorate Order (134) Discrepancies tool (25) Discripencies tool (1) DM Utility (15) DOP Browser (3) DOP Order (56) DOP Tools (28) DoPT (178) Downloader (4) Downloads (3) drivers backup (5) Election Commission of India (16) Employment News (159) Encashment of EL (3) EPFO (22) Establishment (8) Exam Materials (27) Exam Result (47) examination (77) Excel Calculation Sheet (13) Exhibition (8) Fake Appointment (5) finacle (712) FMenu (10) Foreign Articles (4) Frequently Asked Questions (10) Gazette Notification (33) GDS (948) GeM portal (4) General (982) General Financial Rules (8) Gmail (19) Government Employee (2) Government Offices (1) Gratuity (22) Guidelines (50)