VisualGA

An Innovative Solution to Administer General Assistance

VisualGA Server Migration (Reinstallation) Procedures

VisualGA Client workstations communicate with the VisualGA Server, which is typically installed on the township file server.  In order to successfully migrate the VisualGA Server to a new computer, the following procedure is required:

Short Version

1) Coordinate the re-installation date between your IT professional and VisualGA support (support@visualga.net).  We will need 2-3 business days advanced notice.

2) Install all pending windows updates and reboot if necessary.  If a pending reboot is required, we will need to reboot prior to installation.  SQL Server cannot be installed with a pending reboot due to windows updates.

3) Prior to installation, create a share on the new server named VisualGA (case sensitive) and apply read/write share and NTFS permissions for all groups/users who will be using VisualGA. This step is required regardless of whether the installation is for a single user or multiple users. When all users are finished with VisualGA on the old server, move the files from the old share to the new share.  

4) VisualGA Support will now install the server software via a remote support session.

5) While VisualGA support is installing the server software (Step 4), your IT professional can either manually change the VisualGA.exe.config files on all client workstations to point to the new server, or the client workstations can be installed via www.visualga.net/install (administrator rights required) and when prompted, enter the new server name.

6) If you are using windows firewall, we will need to allow sql traffic through by granting access to the sql server service, the sql browser service, and UDP port 1434.

7)  Make sure the server has a backup power supply (UPS)

Long Version

1)  Coordinate the re-installation date with your IT professional and VisualGA support (support@visualga.net).  We will need at least 2-3 days advanced notice with the date and time you would like for us to install the VisualGA server.

2) If you are purchasing a new computer that will host the VisualGA Server, all Windows updates must be completed by your IT professional.   If any of the updates requires a reboot, the computer must be rebooted prior to VisualGA Server re-installation.  We suggest you reboot regardless just to be certain that we will not need to reboot prior to installation.

3) Your IT professional will need to create the VisualGA folder and share on the new server and apply READ/WRITE share/NTFS permissions. When all users are finished and have exited VisualGA, the files on the old share can be moved to the new share. Review our system requirements page for more information.    Determine a folder and time of day when the daily VisualGA database backup will occur.   The default is VisualGA\Backup at 6:00pm.  We recommend this location since you should perform a cloud backup for the entire VisualGA share, which includes the run time files for distribution to any client workstation as well as any client file attachments (pay stubs, identification, etc.).  

4) VisualGA support will give you a remote support key which you can use at www.fastsupport.com to initiate a GoToAssist remote session.  Once connected, VisualGA support will install the VisualGA Server software.  While doing so, we will also need access to the old server to backup the database and move the files from the old server to the new server.  At this point all VisualGA users will need to log out in order to prevent data loss.   You will need to either open an RDP session from the new server into the old server or be prepared to start a second remote session to access the old server.

5) We require at least one client workstation to be working before the session is complete. While VisualGA support is installing the server software (Step 4), your IT professional can either manually change the VisualGA.exe.config files on all client workstations to point to the new server, or the client workstations can be installed via www.visualga.net/install (administrator rights required). Note: Depending on your security settings, you may receive a Windows SmartScreen prompt when running the setup program.  You will need to click the "run anyway" text.  Not to worry - we have a digital signature applied to our installation program (as well as VisualGA itself).  If you right click on the actual setup.exe file you will see a tab called "Digital Signatures" you will see that the setup program is signed by a certificate authority.

6)  If you are using windows firewall, we will need to allow sql traffic through by granting access to the sql server service, the sql browser service, and UDP port 1434.

7) It is very important that the VisualGA server, whether it a true server or workstation, MUST have a backup power supply (UPS) in the event of sudden power loss.  Otherwise, data loss can occur if power is lost to the VisualGA server.

It is imperative that your IT professional does not attempt to perform the installation on their own.  This includes installing SQL Express and attempting to restore the VisualGA database.   There are many processes involved with the VisualGA installation, and it is impossible for your IT professional to know what these processes are.  If your IT professional does attempt to install SQL Express and restore the VisualGA database,  they will be required to remove SQL Express and reboot the server.  You will then need to coordinate the re-installation with VisualGA support as described above.  Your support agreement includes VisualGA Server re-installation, and there is no additional cost to do so.

Thank you!

The VisualGA Team

 

© 2005-2021 VisualGA.Net. All rights reserved.
Designed and Maintained by NJS Enterprises, Inc.