Breadcrumbs

Switching a SQL instance to mixed authentication mode

This support note applies to:

  • AO Practice Manager (NZ)

  • AO Practice Manager (AU)

  • AO Workpapers (AU)

  • AO Statutory Reporter (AU)

  • AO Tax (AU)

  • AE Workpapers (AU)

  • AE Statutory Reporter (AU)

  • AE Document Manager (NZ)

  • AE Practice Manager (NZ)

  • AE Practice Manager (AU)

  • AE Document Manager (AU)

  • AE Tax (NZ)

  • AO Corporate Compliance (AU)

  • AE Tax Series 6 & 8 (AU)

  • AE Tax (AU)

  • AE Corporate Compliance (AU)

Article ID: 35184

These instructions require technical expertise

Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.

MYOB requires mixed authentication mode on the database instance for some features to work. If you have installed SQL with Windows authentication you can change this by selecting Mixed authentication mode and enabling the SA user. Then restarting the instance.

To change security authentication mode

  1. Follow the menu path: Start > All Programs > Microsoft SQL Server 20xx (where 20xx is the currently installed / configured SQL version for MYOB) > SQL Server Management Studio. The Connect to Server window opens.

    Ensure you are logged into Windows as the Windows user who originally installed SQL.

  2. Ensure the server name is correct, select Windows Authentication and click Connect. The SQL Server Management Studio window opens.

  3. Right-click on the server name and select Properties.The Server Properties window opens.

  4. Click Security select the SQL Server and Windows Authentication mode option then click OK. The Server Properties window closes.

  5. Expand the Security folder then expand Logins.The list of users appears.

  6. Right-click on the user sa and select Properties. The Login Properties window opens.

  7. Click Status and select the Enabled option under Login then click General. The general user information appears.

  8. Call MYOB Support for the password.

  9. Click Close. Microsoft SQL Server Management Studio closes.

  10. Once this has been done please restart your instance or reboot the server for the change to take effect.