Oct 25, 2014

Change SQL Server name without Uninstall


Complete Steps to Change SQL Server Name

In PO Server Configuration, Most of the time we are forget to rename the Computer at the time of installation. it may continue in SQL Installation also.

  • Operation system may assign the computer with some letters like DOP-a754fs2g. In SQL installation server name we does not make any changes, we may choose default instance.
  • we may find this issue at the time of connect the SQL server

Easy way to Change SQL Server Name

Before do the DOP software configuration, just rename the Server / Computer Name then, SQL server name automatically change if you have selected default instance at the time of SQL Server Installation.
Note: After dop software configuration never try this one, problem may occur with link server and some other configuration.

Steps to Rename in SQL

When one changes the name of the computer running the SQL Server, one needs to perform the following steps to ensure that SQL Server also uses the new updated name. 
  • First to check whether the SQL Server has the correct name, execute the following query
SELECT @@SERVERNAME                 AS oldname,       Serverproperty('Servername') AS actual_name
  • @@Servername gives the computer name that has been set/registered with SQL Server Serverproperty('Servername') provides the newly updated name from windows.

If @@servername,Serverproperty('Servername') results are different then one should update the new name on the SQL Server. To update, follow the steps provided below.

step 1 :- sp_dropserver/sp_addserver

EXEC  Sp_dropserver   'oldservername'EXEC  Sp_addserver   'newservername' ,   'local'

step 2 :- update sysjobs

Applies only for SQL 2k.

USE msdbUPDATE sysjobsSET    originating_server = Serverproperty('Servername')

step 3 :- Restart SQL Service 

Restart SQL Services for the changes to take effect.

Java Run time Environment v8 Google Drive Download


Download JREv8u25 from Google drive

Download Java for your desktop computer now!

Better browsing

Java is essential for many websites to work well.

Java is fast 

The new Java is faster than ever

Do more with Java

Java works behind the scenes to make McCamish software and Finacle applications work better in DOP

Download JRE from Google Drive


Official Site Download Link

Group Update Provider for CSI Antivirus

A Group Update Provider is a client computer that you designate to locally distribute content updates to clients. A Group update provider download content updates from the management server and distributes the updates to itself and other clients.
One advantages of Group Update Provider use is that it helps you to conserve bandwidth by offloading processing power from the server to the Group Update Provider. Group Update Provider are ideal for delivering content updates to clients that have limited network access to the server. You can use a Group Update Provider to conserve bandwidth to clients in a remote location over a slow link. Setting up a Group Update Provider is easier than setting up an internal Live Update server. Group Update Provider are less resource-intensive and so reduce the load on the management server.

Thanks to
PMU - MP Circle

Transfer of accounts / certificates between CBS and Non CBS


Finacle : Transfer of accounts / certificates between finacle CBS and non finacle CBS Post Offices

Transfer of accounts/certificates between finacle CBS and non finacle CBS Post Offices.

In Sanchay Post, there is a provision to transfer any account to any post office and it generates Advice of Transfer along with Transfer Journals. Certificates issued by other offices can be discharged under the option Discharged at Other Offices after verification. 

  • In Finacle CBS application, the account can be transferred to any CBS post office only.
  • Similarly, non CBS post office can transfer account/certificate to Non CBS post Office only. 
  • In Finacle CBS Application, there is no need to generate any AT or Transfer General or do the pairing. 
  • Only, the post office, after satisfying the genuiness of depositor, has to change the home SOL (Post Office) of the account and account will be transferred instantly. 
  • A report can be generated showing accounts transferred from one SOL to another in all CBS post offices.
  • Certificates issued from non CBS Post Offices cannot be discharged at CBS Post Offices.
  • Certificates issued from CBS post offices can be discharged at any CBS post office by changing the home SOL of the certificates.
  • PPF and SCSS accounts can be transferred IN and Out from CBS post offices to Banks and from Banks to Post Office.

Oct 24, 2014

IFSMO Verification issues and Solution


Solution for IFSMO Verification issues


IFS MO received and delivered successfully but it does not come for Postman verification.


Please upgrade the office properly and sequentially from Megdoot 7.0 to latest 7.9. The updates are available in the ftp site. Please ensure compliance to proper procedure and pre-requisite.

Read Me

Download the IFS MO Update


  • Download attached IFSMO from above link.
  • Execute all the exl using Script Tool.

Postman : sqldumpexceptionhandler process 51 Issues and Solution


Solution for sqldumpexceptionhandler process 51..

An access violation exception may occur, and you may receive the following error message:

Run-time error '-2147467259 (80004005)'
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.


To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000.
  • Download and  install Service pack 3a 
  • Download the latest version of Service Pack 4 and install it


Service Pack 3a and Service Pack 4 both are available in above link

CBS Discrepancies Tool v2.0


CBS Discrepancies Tool v2.0

  • Clear TD Accounts not having passbook issues.
  • Clear Minor Flag Discrepancies.
  • More options will be included soon.

Download Discrepancies Tool

Developed by
Rajesh C R
Kindly send suggestions to rajeshcr2007@gmail.com

Solution for Sanchay Post Data Windows Error


Fixed Sanchay Post : Invalid object name 'form_table'

After Apply SID or Fix DCL User in Sanchay Post or in some other times we have faced the issues like in Sanchaya Post
Data Window error
Select error : Invalid object name 'form_table'


  • Open SQL Enterprise Manager > Security > Logins >DCL Properties.
  • Uncheck (deselect) System Administrators in Server Roles.
  • DCL Should have only one server role that is "Bulk Insert Administrator".
  • Now you can access the Sacnchay Post without any issues.

Oct 23, 2014

Five tips to improve windows xp performance


1. Cleanup and defrag

Yes, I know, the good old cleanup and defrag. But seriously, you can’t expect your computer to be fast if it’s cluttered with junk and has file fragments scattered all over the hard drive.
Windows XP has built-in disk cleaner and disk defragmenter. To access the Disk Cleanup tool, go to Start –> (All) Programs –> Accessories –> System Tools –> Disk Cleanup. And if you want to use the Disk Defragmenter, go to Start –> (All) Programs –> Accessories –> System Tools –> Disk Defragmenter.
However, a lot of people prefer using third-party defrag utilities, like Auslogics Disk Defrag or Piriform Defraggler, because the built-in XP one is pretty slow and doesn’t do a very thorough job.

2. Uninstall programs you never use

A lot of people love trying out new software. So, they download programs, install them, run them a couple of times, and… sometimes never use them again! Sounds familiar, doesn’t it? Having too many programs can make your computer really slow, not to mention the amount of hard drive space they take up.
To see currently installed programs, go to Start –> Settings –> Control Panel –>double-click Add/Remove Programs. Review the list and uninstall programs you never use.

3. Optimize XP appearance settings

If speed is your top priority, it’s recommended to adjust XP appearance settings for best performance. Visual effects that we are so used to waste system resources. And if you think that it’s only the graphics card that has to deal with them, you’re wrong – CPU and RAM are affected as well.
Luckily it’s very easy to optimize XP for best performance by turning off unneeded visual effects:
  • Go to Start –> Settings –> Control Panel;
  • In the Control Panel clickSystem and go to the Advancedtab;
  • In the Performance Options window select Adjust for best performance;
  • Click OK and close the window.
This will turn off all visual effects, which is especially good for less powerful PCs and netbooks. But if you want Windows XP to look sleeker, leave the following boxes checked:
  • Show shadows under menus;
  • Show shadows under mouse pointer;
  • Show translucent selection rectangle;
  • Use drop shadows for icons labels on the desktop;
  • Use visual styles on windows and buttons.

4. Speed up Windows Explorer

If you feel that Windows Explorer takes too long to start, there is a way to speed it up. Windows automatically looks for network files, shared folders, and devices every time you open Explorer. Disabling this option will speed up access to Windows Explorer. To do it:
  • Open Windows Explorer;
  • Click on the Toolsmenu;
  • Then click on Folder Options;
  • Click on the Viewtab;
  • Find Automatically search for network folders and printers check box and uncheck it;
  • Click Apply, then click OK;
  • Reboot your computer.

5. Disable indexing

Indexing can be useful, but it can also make your computer slow and loud, as it takes up RAM and makes the hard drive thrash. The indexing service is used to update the lists of all files on your computer to speed up file search. Disabling indexing will make your search a bit slower, but overall it will speed up computer running XP. Here’s how:

  • Go to Start –> Settings –> Control Panel;
  • Double-click Add/Remove Programs;
  • Click Add/Remove Windows Components;
  • Uncheck Indexing Services;
  • Click Next and then click Finish.

Export IMO Report in Internet Explorer Issues and Solution


Problem Noticed

SQL Server Reporting Services report export failed: "Internet Explorer cannot download …ed.ReportViewerWebControl.axd from"

Using SSRS (Microsoft © SQL Server Reporting Services) you may encounter following problem: once you select export of the currently displayed report in one of comfort formats -

your Internet Explorer pops-up following error:

Solution for IMO Report Generation Error

The reason is: you are using SSL/TLS to connect to SSRS and “Do not save encrypted pages to disk” setting of Internet Explorer is activated:
Uncheck the box and retry.

Pending Reports of Project arrow Request ID in Sanchay Post


Generate of Project Arrow Request ID pending Report

All the Non CBS Post offices had requested to create Project Arrow request ID before do the transaction of Transferred Out / Closed account.
In Sanchay Post 
  • Counter PA can create the Request ID for XFRD-OUT / CLOSED account.
  • Click on Project Arrow > Select option of Request for Account Closure / Transfer
  • Enter Account Number and generate the Request for each accounts.
  • After complete the transaction of Closure / Transferred , Open Updation form to update the Transaction.

Generate Pending report of PA Pending forms

  1. Click on Project Arrow form > Report Click new form.
  2. Select Customer Report then OK.
  3. In Status Select as Pending to generate Pending PA Request.

Oct 21, 2014

Solution for TD Accounts Not Having Passbook


Tool for TD Accounts not having passbook

Rajesh C R Developed a Tool for TD Discrepancies in DPT v4.4 not having passbook issues.


  • Download attached Tool from PoTools.
  • Execute in Server Machine at Once using Windows authentication mode.
Thanks to

Rajesh CR, 
PA (Technology), 
Kattappana HO.

Install Olivetti Passbook Printer using Software


Olivetti Passbook Printer Software

Passbook printer installation is little difficult if don't know how to install the Passbook printers in Windows Seven or Eight OS. here PoTools provides simple way to install the Passbook printer drivers in easy way.
Most of the drivers was not for Windows 64 bit Operating System i.e in Windows 7 or Windows 8

Download Olivetti Installer

  • Download Passbook printer driver for windows 7 / 8 from PoTools.
  • Open Olivetti Driver after plugin Olivetti Printer with your Machine.

Image Re-sizer Tool for ePost Scanned Message


VSO Light Image Resizer

  • Resize pictures, resize photos and resize images – compress, convert, and easily create copies of your pictures
  • A fast batch photo resizer
  • High quality results using ultra fast multi-core, photo resize technology
  • High quality image resizing filters – lanczos and bi-cubic  for best compression quality, and linear for speed,
  • Create e-mail friendly images or use them for internet publishing
  • Sort, rename or add a watermark to protect your pictures to be stolen.
  • Use the profiles library – iPhone, iPad mini, forum, HQ
  • New – create custom pdf pages !
  • Easy to Convert JPEG to PDF

Download VSO Resizer

View / Print out Scanned ePost Message instead of Blank Print out use Fire Fox Latest version. for more info

Google Plus Followers :: PoTools ::

Some Important Tags at PoTools

Aadhar Software ( 3) BO Account verification Tool ( 2) BO Tag ( 4) Bootable USB ( 4) Bulk eMO Payment ( 1) CBS ( 53) ccleaner ( 3) Certificate ( 3) COD ( 46) Data Profiling Tool ( 17) DB Tools ( 5) DBA Updater ( 10) DBAnalyzer ( 63) despatch ( 18) despatch error & Solution ( 21) Discrepancies tool ( 9) Discripencies tool ( 1) DOP Browser ( 3) DOP Clients Configuration ( 2) DOP Tools ( 27) Downloads ( 2) drivers backup ( 4) eMO ( 19) eMO Client ( 8) ePayment ( 10) ePayment Cheque ( 1) ePayment error ( 4) ePayment updates ( 1) ePost ( 10) IMO ( 7) interest calculator ( 10) interest Posting ( 5) interest Rate ( 5) MM 7 Update 8 ( 12) MM 7 Update 9 ( 44) MM Update ( 18) mm7.3 errors ( 24) Negative List Updation ( 13) newupdate ( 110) NREGAEMO error ( 5) Parcel Net ( 21) passbook printer ( 7) PLI Calculator ( 2) PO Tools ( 45) point of sale ( 17) POSB Calculator ( 9) Postman ( 46) postman error ( 33) printer ( 9) PT Tools ( 8) R Net Communication ( 10) RD Customer Package ( 2) RNet Communication ( 9) Sanchay Post ( 30) Sanchaypost error ( 26) SB46 Intimation tool ( 7) SBCO Utility ( 35) sdc updates ( 9) Signature Tools ( 6) softwares ( 16) SOSB Tools ( 4) SP Patch updater ( 32) SPCOD ( 13) Speed Net 4.1.1 ( 9) Speed Net 4.2 ( 28) SpeedNet error ( 16) Speednet update ( 21) SQL and windows ( 20) sql backup ( 8) SR Tools ( 15) sub accounts ( 9) tariff revision ( 4) TDS Software ( 4) treasury error ( 9) usefulpost ( 110) VP Intimation ( 5) Weblink ( 25) windows 2003 server update ( 8) windows troubleshooting ( 13)

PoTools Followers

Contact Form


Email *

Message *

Useful Forms

Total Pageviews

Live Users