Changing the default password for 'sa' username in SQL

• Log in to SQL Management studio using Windows authentication.
• Go to Security > Logins.
• Right-click the username and go to Properties.
• Select Server Roles and make sure sysadmin is selected.

1. Log in to SQL Management studio using Windows authentication.
2. Go to Security > Logins.
3. Right-click the username and go to Properties.
4. Select General and check if Enforce password policy is selected.
   

   

When you run the 5.4.46 installer, you'll be prompted to change the password if you're using the default password.

1. On the server, double-click the 5.4.46  installer file to start the installation.
2. After you've accepted the terms and conditions, if you're using the default password for sa username, you'll see the following window.
   

   

   
   
   
3. If you want to enter a new password, complete the fields and select Save. Make sure that you follow SQL's Changing the default password for 'sa' username in SQL#passwordpolicy if you have the Enforce Password policy enabled (see above). If you don't meet the password requirements, you'll see an error. See FAQs (see below) for error details.
   We'll update the new password in AE/AO (in tax letters and tax homepages). The installation will continue after your password is changed.

4. If you want to change the password later, select I'll change my password later and select Save. You can do this later by running the SAPasswordUpdate.exe file. The installation will continue.

   

   You can also change the sa password using SQL commands. See Resetting the SQL password for 'sa' username.

You can run this file:

• to change the default sa password.
• to create a sa password if you've forgotten it.

If you've installed 5.4.46 and want to change the sa password, you can only change it running this utlity file.

1. On your server where the SQL database is located, go to C:\Program Files(86\MYOB\MYOBACCT\SAPAsswordUpdate folder.
2. Double click SAPasswordUpdate.exe file.
3. If we detect the default password for sa:
   1. You'll see the following window:
      

      

      
      
      
   2. Enter the password and click Save. You'll see the confirmation window.
      
      

      

4. If you're not using the default password but want to change the password:
   1. In the Change your sa password window, select Yes if you want to change the password.
      

      

   2. Enter the new password and confirm the same and select Save.
      

      

Updating the password in AE/AO

 If the password is updated in SQL Server and not in AE/AO, you can manually update the password.

1. Login to AE/AO.
2. Go to Maintenance > Tax > Settings.
3. On the left Tasks bar, click Edit connection details.
4. Enter the new password in the Password field and click Test. Connected successfully to the database message appears.
   

   

   
   
5. On the left Tasks bar, click Connect to Tax database. Integration with Tax is complete message appears.
6. Confirm you're able to open any tax returns without any errors.

Updating the password for tax letters

Open a tax return from 2007 to 2022 and go to Utilities > Control Record > Defaults and enter the SQL password then press ENTER twice to save.

Update the password in schedule backup

1. Login to AE/AO as an administrator or superuser.
2. Select Maintenance > Backup > Schedule Backups on the main menu.
3. Click Edit user details.
   
   

   

4. Select Specify SQL Server user and enter the new Password. Click OK.
5. Click Schedule.

You can run the SAPasswordUpdate.exe anytime you want to change the password for sa username in SQL.

Just follow the steps from Changing the password manually using the SAPasswordUpdate.exe file.