You are here:Home»KB»Applications»Sage»How to Install Sage Taxation & Instant Taxation
Wednesday, 23 June 2010 00:00

How to Install Sage Taxation & Instant Taxation

Written by
  • sage taxation is SQL based
  • you need to run a manual backup so that the backup is then placed at
    c:\Shared Files\Sage Tax Backups\
    it is then backed up from that location
  • there are good install and upgrade instructions on the install disc

To install sage taxation as a network system:

on the server:

  • Install sage Taxation on the server
  • install microsoft mysl express 2005 sp3 only
  • add these to the firewall
    1433 TCP
    1434 UDP
    sqlbrowser possibly not - C:\Program files\Microsoft SQL Server\90\shared\sqlbrowser.exe
    mysqlserver - C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exec
  • create a folder c:\SageTax and share it out as 'Tax Share'
  • map it locally as t:\

then when installed on server,

On the Client PC:

  • map t: to \\server\Tax Share
  • install workstation version,(files only)
  • location of mysql server is
    SERVER\SageTax
    password needed is $agedadm1n

Additional Stuff:

To run a manual backup

  • go to programs/Sage Practice/Tools/Sage Taxation/Sage Taxation/Backup & Restore.lnk
  • all users should be logged out, if there are users still in sage taxation it will warn
  • check backup location is set to c:\Shared Files\Sage Tax Backups\  , this should be replicated automatically throughout your clients. The setting can be accessed by clicking settings in the 'Backup and Restore' utility
  • and then click backup
  • This process is intitiated manually via this process and then by the fact that the backup is then created in c:\Shared Files\Sage Tax Backups\ it is backedup by the main backup system

Setup a schedule backup on the server

  • the backup location is configured in the start menu.
  • all progs/sage/tools/backup and restore under settings.
  • the security option that is there is recommended by the sage guy prior to upgrades because of
    the security data it stores, but not data essential as i am aware.
  • next, a schedules task needs to be set in windows.
  • goto control panel
  • select scheduled tasks
  • run this
    c:\Tax Share\SageData\UKTax\Master\Apps\Tools\BackupRestore.exe /BACKUP
  • Set weekly or whatever, data will now backup to specified directory

To restore data:

  • put the backup file on the server,
  • then run backup and restore tool on the workstation
    restore password is :
    mck2ptbgdt

New Install from network

once sage personal tax is installed on the server you can just do the following to install sage tax from the server

  • create the following persistent network share
    net use T:"\\server\Tax Share" /yes
  • run T:\SageData\UKTax\Master\Install

Upgrading

when you have set sage personal tax up as a network installation:

  • insert the cd from sage in to the server and proceed with an upgrade (similiar procedure as downlod section below)
  • when performing an upgrade the system will perform a mandatory backup
  • when the upgrade is perfomed on the server it will pass the update to the client machines when they log on for the first time they will performa  workstation update

when you download the update or installer (it is a self conatined archive)

  • run it, next,
  • i accept and next,
  • installer now checks resoucses and installed stuff, when finished click next
  • your practice has v14.01 installed, this will be updated to v15.00, (note server is called SERVER/SAGETAX), click next
  • check info and click install
  • it will now check the database and the data etc..
  • the installer will continue thourgh its procedure now and at some point will do an automatic backup (i assume default location)
  • then click next
  • click finish

Additional notes

Sage Taxation will not work. it cannot find the master database and timed out.

  • This occured after installing comodo firewall. i also used comodos own dns settings.
  • sage instant taxation/compliance utilises DNS to find the servers name and what as happening while using these dns serves was the computers name it was searching for was coming back prefixed like server.dlink.com and therefore would never be found.
  • So Remove comodo DNS from the ethernet or WIFI of Sage client machines. It could possibly be added tot he router itself.

There were some new backups relate to sage practice soltions at C:\ProgramData\Sage\Practice Solution\SQLBackups

These were caused by sage practice solution being installed as part of the XRBL update from sage which we do not have a licesnse for and they have shelved it for the purpose it was intended for.

So sage installed a temporary license to edit the automatic backups to set the to C:\Shared Files\Sage Practice Solution Backups  and to also turn them of as they are not needed. later iterations fo sage software will require sage practice solutions so this why it is left installed.

Read 1467 times Last modified on Wednesday, 26 November 2014 19:19