MYOB AE 2019.0—Common tasks and troubleshooting
Use one of two methods to back up your MYOB AE database:
Backing up your database using MYOB AE
Open MYOB AE.
Select Maintenance > Backup > Back Up Now.
Press F1 on the Back up now window to access the online help for more information.
Backing up using the Microsoft SQL Server Management Studio
Select Start > Programs > Microsoft SQL Server 2008 or later > SQL Server Management Studio. The Connect to Server window opens.
Enter your login details and click Connect. The Microsoft SQL Server Management Studio window opens.
Expand Databases to locate VPMSER.
Right-click VPMSER and select Tasks > Back Up. The Back Up Database - vpmser window opens.
Click Remove to remove any files shown in the Destination field.
Click Add. The Select Backup Destination window opens.
Select a location and type a name for the database in the File name field.
Click OK.
Select Options.
Select Overwrite all existing backup sets.
Click OK.The Backup of database 'vpmser' completed successfully window opens.
Click OK.
The following instructions vary with each version of Microsoft Windows.
Identifying MS Windows, MS Workstations Operating Systems version |
|
Identifying Management Accounting System Integration Version and Accountants Enterprise version |
|
Identifying MS SQL Server and MS .NET Framework version | Windows 8 or later
Windows 2008 Server
|
- Right-click the MYOB Document Manager icon in the System Tray.
Select Exit from the menu.
- Logon to a workstation as a team member who adds documents to MYOB Document Manager.
- Click Start > Programs > MYOB > Document Manager Shortcuts. The Document Manager Shortcuts icon displays in the System Tray.
- Repeat the above steps on each workstation.
This installation includes a change to your computer’s registry settings to turn on Enable Linked Connections. This change is required on each workstation and server that uses mapped drives.
If the Enable Linked Connections setting is not turned on you may experience issues when installing and using your MYOB software.
After installation, you may be prompted to restart because of the change to the registry for the Enable Linked Connections setting. MYOB recommends you restart as prompted.
For more information, see Enabling Linked Connections in Windows.
User Account Control (UAC) is a windows feature which informs you when a program makes a change which requires administrator-level permissions.
UAC works by adjusting the permission level of your user account. Even if you are logged in as a user with administrator access, the server may use the security settings of a standard user.
If you encounter errors due to administrator-level permissions, you may need to disable UAC before installing your MYOB software.
To turn off User Account Control in systems where the Start menu is operational: |
|
To turn off User Account Control in systems like Windows 8 where the Start menu is not enabled: |
|
When opening MYOB AE, an Open File Security Warning message may appear. Click Run to proceed and open and log into MYOB AE. If you keep getting this warning message, you should restart your computer.
If the server where Corporate Compliance is installed has firewall protection that prevents unauthorised access, this will have the following effects when trying to set up a client workstation for Corporate Compliance:
You cannot locate the server when installing Corporate Compliance on a client workstation.
You cannot run Corporate Compliance from a client workstation, as the program cannot locate the server.
You need to add an exception to the firewall rules so that authorised users can gain access to the Corporate Compliance database.
Step 1 — Add a firewall exception for the SQL program
- Open Control Panel and open the Security Centre.
- Click the Windows Firewall option.
- Select the Exceptions tab in the Windows Firewall dialog.
- Click Add Program.
- Browse to the Corporate Compliance SQL program at C:\Program Files\Microsoft SQL Server\MSSQL10.SOL6CC\MSSQL\Binn\sqlservr.exe location and click Open.
The file sqlservr.exe is listed in the Add a Program window. - Select the option Change Scope.
- We recommend you select the option My network (subnet) only.
- Click OK to return to the Add a Program window.
- Click OK to return to the Windows Firewall Exceptions tab. The program sqlservr.exe is then listed and selected in the list.
- Click OK to save the settings.
Step 2 — Open a port in the Windows firewall for TCP access.
- Open Control Panel and open the Security Centre.
- Select Windows Firewall.
- Select the Exceptions tab in the Windows Firewall dialog.
- Click Add Port.
- In the Add a Port dialog:
- Type SQL Server Browser in the Name text box
- Type 1433 in the Port number text box.
- Select the option UDP.
- Click OK to return to the Windows Firewall Exceptions tab. The program SQL Server Browser is then listed and selected in this list.
Click OK to save these settings.
Windows 8 or later
This issue is due to the Corporate Compliance Utilities module creating a log file under Program Files. The work around is to run the Utilities as Administrator.
Option 1 : Run Utilities as Administrator:
Right-click Utilities.
SelectRun As Administrator from the pop-up list.
Option 2: Turn off UAC.
If a number of applications experience difficulties with the Windows 8 (or later) UAC settings you can choose to turn off UAC:
Click the Windows Start button.
In the Search programs and files field type User Accounts.
Click on the shortcut Change User Account Control Settings.
Change the UAC settings slider to Never Notify.
The regional settings on your computer are not compatible with the version of MYOB AE you are trying to install.
This message means that you are trying to install MYOB AE:
for a region that is different to your computer’s regional settings, or
on a workstation that has different regional settings to the server installation of MYOB AE.
Both region and language format are controlled using Window’s regional settings.
To continue after receiving this error message you need to:
Close the MYOB AE installation menu.
Update the regional settings to match the Australian version of MYOB AE. Steps to change your regional settings differ according to the environment.
If you're changing your regional settings you should also check your system locale.
Restart your computer to have these settings take effect.
Re-install MYOB AE, as applicable.
Continue with the instructions provided in the installation guide.
Changing your regional settings
To change your computer’s regional settings on specific operating systems, follow the instructions below:
Windows 8 or later | On Windows, the Start menu is not enabled.
|
Your computer’s system locale must be set to one of:
English (Australia)
English (New Zealand)
English (UK)
English (US).
This setting is controlled using Window’s regional settings.
Changing your system locale
For instructions on changing your computer’s system locate settings on specific operating systems, follow the instructions below.
Windows 8 or later | On Windows, the Start menu is not enabled.
|
For instructions on changing your computer’s system locale settings on other operating systems, refer to the online help on your computer.
Press Ctrl+F and type the error you're looking for
Error | Solution |
---|---|
You must log on as system administrator to install this software | Ensure that your login has administrator rights when performing the installation on the server and on each workstation. |
Errors due to Administrator-level permission | Any Administrator-level permission errors which occur during the installation of MYOB AE may be due to User Account Control settings. For example, an error which occurs when the Installation Wizard has trouble accessing a mapped drive during the installation. If such errors occur, you should disable User Account Control for the duration of the installation. |
Your computer name is not compatible with this software | Your computer name is not compatible with this software. The computer name must be 15 characters or less. Call MYOB Support on 1300 555 666. We will provide you with information on how to proceed with the installation. |
The regional settings are incorrect | The region you select must match the regional settings on your computer. When installing MYOB AE:
Both of these settings are controlled using Window’s regional settings. To continue installing the software you need to either:
or
|
The operating system that you are using is not supported by MYOB | This message indicates you will need to upgrade your operating system before installing MYOB AE. For example, if you run Windows Vista you will need to upgrade to a current Windows operating system version as Window Vista is no longer supported by MYOB. MYOB adds new environments to our testing schedule and periodically discontinues testing of older environments. As a general rule, MYOB can only test environments that are fully supported by Microsoft. The complete list of supported operating systems can be obtained from myob.com. |
There was an error with the network connection | Ensure your network is configured correctly before continuing with the installation. There may be issues with your server service, network or file sharing settings. Contact your system administrator for help. |
You cannot install MYOB AE on this computer | Please note you cannot install MYOB AE on this computer because MYOB Accountants Office (AO) is already installed. This error means that a MYOB product is already installed on your system. You are not able to install MYOB AE and MYOB AO on the same computer. |
You need to run a full version of the installation | When reviewing the System check results screen you may see failures if the following components are not installed on your computer:
When viewing the details of these failures, you are instructed to install each of these components manually or alternatively run a full version of the installation. This error can occur if you are attempting to install MYOB AE using the LITE version of the install from the MYOB website and you do not already have the components installed on your computer. These components are available in the FULL version of the install from the MYOB website. |
The selected file path location is not on this computer | The location you have selected for the installation is not on this computer. Please select a file path location on this computer. |
The selected file path name cannot contain any spaces | Please select a different file path location or cancel the installation to exit. The file path you have selected for the program location contains spaces. Remove the spaces and browse to the new location. |
These routines will export all data from the files DZZTV?? | If you see this error - These routines will export all data from te files DZZTV?? when generating an estimate, call MYOB Support. |
Unable to load code module | If you see the error - Unable to load code module, call MYOB Support and quote KB0023617. |
There was a problem connecting to the database | Before installing, the installation wizard will attempt to log in to your existing SQL database. If the Login ID and / or password are incorrect an error message appears indicating that there was a problem connecting to the database. See The selected database is not on this computer in Database issues for more information. |
Machine name not unique | See Error: "Machine name not unique" |
SR DAL Datasource error | See Troubleshooting SR DAL connectivity |
User SUPERVIS has been granted exclusive access to system services | See Error: "User SUPERVIS has been granted exclusive access to system services" |
This folder is managed by another installation of system services | See Error: "This folder is managed by another installation of system services" |
Application Template not found | See Error: "Application Template not found" |
I/O error in TCF file" when opening a Tax return | See Error: "I/O error in TCF file" when opening a Tax return |
Still having issues during install?
If you see any errors during installation that you cannot resolve on your own, contact support for help.
When you contact Support provide the log files for both the server and workstation which are located at:
32 bit machines | C:\Program Files\MYOB\MYOBACCT\INSTALL |
64 bit machines | C:\Program Files (x86)\MYOB\MYOBACCT\INSTALL |
This will help us resolve your installation issues quickly.
Error | Cause |
---|---|
Your database is not valid or doesn’t exist | The database name prefix must not contain spaces or any special characters. |
Your database name can’t be found | MYOB Accountants Enterprise requires the database compatibility level to be set to SQL Server 2008(100) or later. Your database hasn’t been detected. |
No database exists in SQL | There are no databases in the selected SQL Server instance. Select another SQL Server instance. There are no databases available to add or upgrade. |
Your MYOB AE database is not valid or has compatibility issues | You have not selected a valid MYOB Accountants Enterprise database. Please select another database. |
The selected database is not on this computer | The selected database location is not on this computer. You must install MYOB AE on the same computer where your database is located. Cancel the installation and re-run the installation on the same computer where your database is located. This error may occur if you are not installing MYOB AE on the server. |
Your Tax database can’t be found | Your Tax database can’t be detected. Please check you Tax configuration settings. The installation can’t continue. Please contact MYOB Support for assistance. |
Your Tax database compatibility level has issues | Your Tax database requires the database compatibility level to be set to SQL Server 2008(100) or later. The installation can’t continue. Contact MYOB Support for assistance. |
Your Tax database is not valid or has compatibility issues | You have not selected a valid MYOB AE Tax database. Please select another database. |
Your database does not contain Tax data | When attempting to access your Tax database, the installation has detected that the MYOB AE database in your existing installation does not contain any Tax data. The setup will continue with a MYOB AE only configuration. Contact MYOB Support for assistance. |
Error | Cause |
---|---|
Configuration incompatibility | Your configuration of MYOB Accountants Enterprise does not support remote databases. Contact MYOB Support for assistance. |
The configuration is not supported | This error message may occur for one of the following reasons:
Contact MYOB Support for assistance, if necessary. |
The installation directory is not valid | MYOB Accountants Enterprise cannot locate the data folders that it requires for this installation. Ensure that you have copied all the data folders to the correct locations. For example, if you are migrating MYOB Tax - Non-SQL, you may not have copied valid Sol64 or Sol63 folders. |
Invalid System Release configuration | MYOB Accountants Enterprise has detected an invalid System Release configuration. To complete this upgrade, select Cancel on any System Services messages that appear during the installation. |
Your System Release installation directory can’t be retrieved | Your System Release installation directory could not be retrieved from the registry. Before running this installation, perform the following steps:
|
The SQL Server is not valid | Your SQL Server instance is invalid. Contact MYOB Support for assistance. |
Your current Tax version is not the correct pre-requisite | The pre-requisite of this MYOB AE installation is MYOB AE Tax 2018.0. Please install MYOB AE Tax 2018.0 before running this installation again. |
Your Tax ledger code can’t be found | You have specified a Tax ledger code that doesn’t exist on your system. To check the Tax ledger code, go to the System Release ledger list and note the code under the Client column. |
Cannot verify Tax ledger code. Check settings in SOL64\TaxInstall.ini. If SQLDatabase exists, ensure SQL Tax is set to True. | There is a conflict in the TaxInstall.ini file. If you have a SQL Tax database, set SQLTax = True in the Taxinstall.ini file located in your SOL64 or TAX folder. |
There is a conflict in the paths of System Release and Tax. One product is referencing a local drive, the other a network path. | Check the TaxInstall.ini file in your Tax program directory. If installing to a network drive, ensure that TaxDirectoryUNC contains a UNC path. |
Error | Cause |
---|---|
Database not attached to SQL Server instance | You must first add a valid MYOB AE database to your SQL Server instance before adding this product. |
You are attempting to add a product that is not compatible | You are currently attempting to add another MYOB product to your current installation that contains MYOB AE Tax - Non-SQL. In order to add the product you must first convert to MYOB AE Tax SQL. If you wish to convert to MYOB AE Tax SQL, contact MYOB Support for assistance. |
You have forgotten to add your products when registering | Please add a product in the Registration screen by clicking the Add/Remove products button. Select one or more new products to add. |
Your new product has been registered, but not installed | Some of the products that you registered have not been installed. To install these products, re-run the current installation of MYOB Accountants Enterprise and select the Add another MYOB product option. |
Error | Cause |
---|---|
Incompatible database | The selected database has already been configured with the selected new MYOB product. Please select another valid database to use with the new MYOB product. |
Invalid database | You have selected an invalid database. Please select a valid MYOB AE database. |
Error | Cause |
---|---|
A repair cannot be performed | MYOB Accountants Enterprise is unable to perform a repair at this time. Possible reasons could be:
|
Your Tax ledger code couldn’t be found | During a repair or re-install, the Tax ledger code configuration doesn’t exist on your system. Please select the correct Tax ledger code. |