Article ID: 37178

<!--Product families-->
<div style="display: none;" data-swiftype-name="productFamily" data-swiftype-type="enum">Accountants Enterprise Suite</div>
<!--Countries-->
<div style="display: none;" data-swiftype-name="country" data-swiftype-type="enum">Australia</div>
<!--Product capabilities-->
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Assets Live (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Workpapers (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Statutory Reporter (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Practice Manager (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE System Release (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Reporter (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Document Manager (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE MAS (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Investments (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Assets (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Tax (AU)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Corporate Compliance (AU)</div>

ARTICLE LAST UPDATED: 23/11/2016 9:36:00 AM

MYOB INTERNAL STAFF ONLY

**DO NOT MODIFY THIS ARTICLE. WHERE CHANGES ARE REQUIRED, REFER TO THE TECHNICAL SERVICES TEAM**

Before you begin the Migration process, you'll need to ensure:

• you are logged in as an administrator user.
• User Account Control (UAC) is switched off.
• Data Execution Prevention (DEP) is set to the default setting.
• any Anti-Virus, Anti-Spyware, Anti-Malware, Firewall or any other such security software is switched off.
• Linked Connections are enabled on any Server 2012 and/or Windows 8 machines.

• the Date and time, language and regional settings are set to the correct region and time.

• .Net Framework 3.5 to 4.6 are enabled/installed.
  • Server 2016: via Server Manager
  • Server 2012: via Server Manager for 3.5 & 4.5, while 4.6 is a manual install.
• the drive that will be hosting the MYOB data is less than 1.8TB in partition size.
• check what MYOB AE products you are licenced for on your current server.
• you're installing the same version of MYOB AE that is currently installed on your existing server
• all ATO PLS reports on your old server have been unscheduled
• there are no tax returns with a status of Transmitting or Transmitted. If you have Transmitted or Transmitting returns, contact MYOB support for assistance.

Before you install MYOB AE, consult the System Requirements page to ensure your setup is compatible with the MYOB software.

If you have any issues with the above, we recommend consulting your IT vendor.

You will need to copy certain directories and files from your old server to the new server to ensure all data is retained.

Copy the relevant files and/or folders listed below for each database in use. For example, if there are multiple tax databases - you may have AETAX1 and AETAX2 - ensure both are copied.

Place these in an easy to access temporary directory on the new server for now.

Locating my S6CLIENT folder

To locate your S6CLIENT folder, in System Release, click Folders on the left navigation pane and note the location of the folder with a reference of S6CLIENT.

Locating my templates and documents

In MYOB AE navigate to the Maintenance menu > Maintenance Map > Documents section. Note down any relevant paths under the following areas:

If these paths are still in use and you're unsure what these paths are for, refer to the help menu. Make sure the files in these locations are copied across to the new server.

Install SQL server on the new server prior to installing using the combined installer.

To install SQL Server 2012 Express to the MYOBACCT instance, refer to KB 33977: Installing Microsoft SQL Server 2012 or 2014 Express with Management Tools to MYOBACCT Instance.

If you are licensed for Corporate Compliance (CC), set the traceflag -T4606 to the SQL instance. Instructions can be found in KB 35298 under "To set the traceflag -T4606 to the MYOBACCT instance for SQL 2012".

After SQL is installed, restore the relevant SQL databases from the backups created earlier. For details refer tor KB 34002: Restoring an SQL database using SQL Server Management Studio.

The databases you need to restore are as follows:

• MYOB AE: Restore VPMSER or AEDB1 databases
• Tax: Restore SQLTAX or AETAX1 databases
• Corporate Compliance: Restore the CorporateCompliance and SystemCatalog databases then, open the VPMSER or AEDB1 database and edit the SQL instance name in the dbo.Configuration table for the row titled CorporateComplianceConnectionString. Press the TAB key on the keyboard to tab through for the change to take affect.

You will need to create a S6SYSTEM directory to store MYOB AE program and data files. This can be located anywhere on the server machine, or on another machine. You will need to refer the installer to this location later.

S6SYSTEM must then be shared and mapped as a network drive on the server and all workstations.

You will also need to create MYOBAE folders under S6SYSTEM and an AESQL folder under MYOBAE. This is so you end up with S6SYSTEM\MYOBAE\AESQL folder paths.

If using Document Manager, you will need to copy across your Document Manager File Store (DMFS) and Intranet Data folder. For inforamtion, refer to KB 23595: Backing up MYOB Document Manager files for information.

You can copy the Document Manager File Store (DMFS) to where you want it.

The Intranet File Store folders must be copied to the default location M:\MYOBAE\AESQL\Knowledge Management\Intranet\Data (Where M:\ is the mapped drive for S6SYSTEM share). You will have to first manually the create folders for Knowledge Management\Intranet\Data under the AESQL folder.

Copy the SOL63 (if you are a non-SQL Tax site) and SOL64 folder to the new M:\MYOBAE\AESQL folder (Where M:\ is the mapped drive for the S6SYSTEM share) on the new server. Then rename the SOL64 folder to Tax.

If you have determined you use the TAX folder and not SOL64, copy the TAX folder into the above AESQL folder instead of SOL64. If you're not sure where your SOL64 or Tax folder is located, refer to KB 28712: Finding the System Release directory

If using MAS and/or Assets, you'll also need to copy the S6CLIENT folder or other relevant folder to the new M:\ drive (Where M is the mapped drive for S6SYSTEM share).

If you're using Corporate Compliance, you'll also need to copy the ELS folder.

Check what version of MYOB AE is installed on the old server and download that version from my.myob.com.au. When the download is complete, install that version of MYOB AE.

During the MYOB AE install you'll be prompted:

• for the location of the MYOBAE folder. Point it to the path created earlier. For example, M:\MYOBAE (where M is the mapped drive for S6SYSTEM share)
• to register MYOB AE. Contact MYOB Support on 1300 555 666 option 4 for licensing.
• whether SQL for AE Tax is used
  • If you are using non-SQL Tax (i.e. SOL63 folder), choose No. You will be prompted for your Tax ledger code.
  • If you are using SQL Tax, choose Yes. You will be prompted to select your SQL instance (i.e. SERVER\MYOBACCT where SERVER is the server name) and MYOB AE SQL database (i.e. VPMSER or AEDB1). Select correct SQL instance and MYOB AE database

Review all information to ensure it is correct, then click Install Now.

If you've licensed for Document Manager: at the end of the install, you will be prompted with the MYOB AE Document Manager File Store setup configuration menu. If your DMFS is on a remote server, deselect the run DM_Config.exe checkbox. You'll need to run the DM_Config.exe file on the DMFS machine from the location noted in the installer.

For further information, refer to KB 37166: Information on the combined installer for MYOB Accountants Enterprise and the AE Installation Guides.

System Release folder paths

1. Open System Services.
2. From within System Services, right-click on a folder in the list and select Properties. The General tab of the Folder properties window appears.
3. From within the General tab of the Folder properties window, in the Local field delete the location then press the TAB key to populate the new local path.
4. Click OK.
5. Repeat steps 2 and 3 for each folder.

Update Keys in MYOB AE Configuration

Open MYOB AE and follow the menu path Maintenance > Maintenance Map > User defined > Configuration. Ensure you update the paths for the CATemplatesPath, Sol6MAS Ledger, System Services keys with new server name (or mapped drive, where a different mapped drive is used on the new environment).

Refresh System Services Links

Check that you can generate an estimate for each tax year from 2005 to the current Tax year. If you can successfully generate a tax estimate, skip this step. If nothing appears, the system services links needs to be refreshed. See KB 28980: Refreshing the System Services links in AE Tax.

Update SA Password in Control Record for Tax Letters and update Create/Update views

Open up a 2007 or later Tax return and follow the menu path Utilities > Control Record > Defaults. Enter enter the SQL password then press the ENTER key on keyboard twice to save.

Open a 2007 or later Tax return and follow the menu path Tax Letters > Create/Update Views and then press OK.

If using a Proxy Server, configure the Proxy.Config file

For information on configuring the Proxy.Config, see KB 36833: Configuring my Firewall or Proxy to work with MYOB AE/AO.

If you're using MYOB Workpapers integrated with MAS, you'll need to run the MAS Integration setup. This can be found in the M:\MYOBAE\AESQL\TAX\setup\MAS Integration folder (where M:\ is the mapped drive) and either:

1. Apply KB 36909 to remove all integrations or;
2. Contact MYOB Support for help with updating all ledger paths via a bulk routine.

If using MAS with Reporter, Assets or Corporate Compliance (Non Integrated), you can install these now.

For MAS with Reporter, MAS does not need to be reinstalled. You will need to download Reporter version 3.5 from my.myob and install these in the following order:

1. Install Reporter 3.5 on the server.
2. Run the workstation setup located at M:\MYOBAE\AESQL\Tax\setup\Reporter Integration\setup.exe (where M:\ is the mapped drive).
3. Delete MYOBAEReporterWorkstation3_4_AU.exe from the Reporter Integration folder if exists.

For more information on migrating MAS with Reporter refer to KB 30735: Migrating MYOB Reporter to a new server.

If using AE Assets, download MYOB Assets version 2.4.3.1 from the my.myob website and install as per the installation guide. After each workstation install of Assets, register M:\MYOBAE\AESQL\Tax\s6db32.dll using an Administrator Command Prompt (i.e. Regsvr32 M:\MYOBAE\AESQL\TAX\s6db32.dll)

If using Non-integrated Corporate Compliance, refer to KB 30820: Migrating your MYOB AE Non integrated Corporate Compliance to a new server.

If licensed for MYOB AE Corporate Compliance, you will need to choose a new CC Backup and ELS location.

To choose a new CC Backup location:

1. On the server, navigate to C:\Program Files (x86)\MYOB\Corporate Compliance\Utilities
2. Open Backup.bat and go to Settings on the left, under Backup and Restore.
3. Click the Change button in the bottom right and navigate to your new CC Backup location. Press OK and close Backup.bat.

To choose a new ELS location:

1. After you've chosen a new CC backup location, from within the Utilities folder, locate and open CCUtilities .exe.
2. On the left under Settings, click on Electronic Lodgment Path.
3. Click the Change button and navigate to your new CC ELS location. Press OK and close CCUtilities .exe. Your Corporate Compliance is now updated to the new server paths.

You'l now need to log into AE and update your connection details:

1. Open MYOB AE and log in.
2. Once you're logged into AE, follow the menu path Maintenance > Corporate Compliance > Settings.
3. Ensure the server name and database are correct, then click Update connection details to ensure the settings are saved.

1. Copy across the templates, styles and documents copied from the old server into the MYOBAE\AESQL folder on your new server.
2. Open MYOB AE and follow the menu path: Maintenance > Maintenance Map > Documents section.
3. Ensure all the paths at task one correctly match the locations on the new server. If required, change these paths in the software to match the files' location.

• You'll need to unshare the shared MYOB folder (for example S6SYSTEM). Talk to your IT on how to unshare a folder.
  
  
• Disable the following services

• on the old server so the users don't access the data from the old server.
  • SQL Server (MYOBACCT) or SQL Server (name of your AE SQL instance)
  • MYOB OntheGo Service
  • MYOB Sync Client Service
  • MYOB Tax SBR Sender Service (if exists)
  • MYOB DM Portal Sync Service (if exists)

To disable the services:

1. 1. On the old server, go to Control Panel > Services.
   2. Right click the service you want to disable, for example SQL Server (MYOBACCT), and select Properties.
At
2. 1. From the Startup type drop-down, select Disabled
from the drop-down
3. 1. .
   2. At Service status, click Stop.
   3. Click OK.

You'll also need to remove the share from the shared MYOB folder (for example S6SYSTEM). Talk to your IT on how to remove sharing from a folder. 

Following the successful migration of MYOB AE to the new server, there are a couple of things that need to be completed post install:

1. Download and apply any software updates as required from my.myob.
2. Log into MYOB AE and navigate to Maintenance > Backup > Schedule Backups and set up the backup cycle.
3. Perform a backup now via Maintenance > Backup > Backup Now to kick off scheduled tasks being active.
4. Schedule a Backup for Corporate Compliance. Refer to KB 36065: Scheduling a backup in Corporate Compliance for information.
5. Ensure integration is running correctly:
   • VizPost - Refer to KB 28302: Error: "Could not find a folder for the supplied pathname" when starting Run CDS Vizpost or launching compliance modules
   • PMPlus - From MYOBAE follow the menu path Maintenance > Tax > Settings and ensure all settings are correct. Where incorrect, use the Edit Connection details button on the TASKS bar to correct the settings. Once completed, click Connect To Tax Database.
6. Run a workstation install as per the relevant section below:

Network setup:

1. If using existing workstations, uninstall any of the following that appear on the workstation:
   • MYOB Accountants Enterprise Assets
   • MYOB Accountants Enterprise Client
   • MYOB Accountants Enterprise Reporter Integration (Workstation)
   • MYOB AE Reporter Integration Workstation
   • MYOB Corporate Compliance
   • MYOB Document Manager Workstation
   • MYOB Intranet Workstation
   • MYOB PDF Manager
   • MYOB Registration Workstation
   • MYOB System Release Workstation
2. Map the network drive.
3. Run the combined Workstation setup located at M:\MYOBAE\AESQL\WorkstationInstall\setup.exe. Refer to KB 37154: Running a combined workstation installation or uninstallation for Accountants Enterprise for details.

4. If you're using...

   • MYOB AE Reporter: run the Reporter workstation setup located at M:\MYOBAE\AESQL\Tax\setup\Reporter Integration\setup.exe
   • MYOB AE Assets:  i nstall Assets 2.4.3.1 and register s6db32.dll (as per instructions above in compliance section).
   • MYOB PDF Manager: install the latest version from my.myob. For more inforamtion refer to KB 34918: Uninstalling and reinstalling PDF Manager on a workstation

Update Practice my.MYOB Settings

1. Log into MYOB AE and follow the menu path Maintenance > Maintenance Map > Online> Practice my.MYOB Settings
2. Enter the practice MYOB Login address, the password and the MYOB Client code (Client ID).
3. Click OK to save.

PLS setup:

Before you can set up PLS, you'll need to complete the steps in Update Practice my.MYOB Settings above.

KB 36044: Error: Lock violation when opening System Release products

KB 34036: Error: "S6DB32.dll is an old version" or "S6DB32.dll is missing"

KB 34288: Document links not opening after a server migration or when your DM File Store is moved

KB 28704: Smart Reports error after a Server migration

KB 29794: Error: "Your licence file is not valid for this computer" or "License file invalid". Please contact MYOB support"

KB 36833: Configuring my Firewall or Proxy to work with MYOB AE/AO