Common tasks and troubleshooting (AE)

Use one of two methods to back up your MYOB AE database:

Backing up your database using MYOB AE

1. Open MYOB AE.

2. Select Maintenance > Backup > Back Up Now.

3. 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

1. Select Start > Programs > Microsoft SQL Server 2008 or later > SQL Server Management Studio. The Connect to Server window opens.

2. Enter your login details and click Connect. The Microsoft SQL Server Management Studio window opens.
   

   

   
   

3. Expand Databases to locate VPMSER.

4.  Right-click VPMSER and select Tasks > Back Up. The Back Up Database - vpmser window opens.
   

   

5. Click Remove to remove any files shown in the Destination field.

6. Click Add. The Select Backup Destination window opens.
   

   

7. Select a location and type a name for the database in the File name field.

8. Click OK.

9. Select Options.

10. Select Overwrite all existing backup sets.

11. Click OK.The Backup of database 'vpmser' completed successfully window opens.

12. Click OK.

The following instructions vary with each version of Microsoft Windows.

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.

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.

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:

1. Right-click Utilities.

2. 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:

1. Click the Windows Start button.

2. In the Search programs and files field type User Accounts.

3. Click on the shortcut Change User Account Control Settings.

4. Change the UAC settings slider to Never Notify.

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

1. Open Control Panel and open the Security Centre.
2. Click the Windows Firewall option.
3. Select the Exceptions tab in the Windows Firewall dialog.
4. Click Add Program.
5. 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.
6. Select the option Change Scope.
7. We recommend you select the option My network (subnet) only.
8. Click OK to return to the Add a Program window.
9. Click OK to return to the Windows Firewall Exceptions tab. The program sqlservr.exe is then listed and selected in the list.
10. Click OK to save the settings.

Step 2 — Open a port in the Windows firewall for TCP access.

1. Open Control Panel and open the Security Centre.
2. Select Windows Firewall.
3. Select the Exceptions tab in the Windows Firewall dialog.
4. Click Add Port.
5. In the Add a Port dialog:
   1. Type SQL Server Browser in the Name text box
   2. Type 1433 in the Port number text box.
   3. Select the option UDP.
6. Click OK to return to the Windows Firewall Exceptions tab. The program SQL Server Browser is then listed and selected in this list.

7. 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:

1. Right-click Utilities.

2. 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:

1. Click the Windows Start button.

2. In the Search programs and files field type User Accounts.

3. Click on the shortcut Change User Account Control Settings.

4. 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:

1. Close the MYOB AE installation menu.

2. 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.

1. Restart your computer to have these settings take effect.

2. 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:

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.

For instructions on changing your computer’s system locale settings on other operating systems, refer to the online help on your computer.