Running the Create user.sql script

This support note applies to:

AO Practice Manager (NZ)
AO Practice Manager (AU)
AO Tax (AU)
AE Practice Manager (NZ)
AE Practice Manager (AU)
AE Tax Series 6 & 8 (AU)
AE Tax (AU)

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.

Article ID: 37110

If you are reading this article there's a good chance that you may be in a situation where you need to run the Create user.sql script. For example, this may be after a server migration and you have been referred here by another article, or on the guidance of MYOB Support.

Download the following Create user.sql script. You'll then need to run this script from within SQL Server Management Studio on the server hosting your data.

Before running any script, we recommend ensuring all users are logged out of all MYOB products and that you have a current backup of the database.

To run the Create User.sql script

From SQL Server Management Studio, follow the menu path: File > Open > File.
From the Open File screen, navigate to and select the script file then click Open.
Select the relevant database from the Available databases drop-down list.
Press F5 or click Execute.

Further information on running SQL scripts can be found in Running a script through SQL Server Management Studio