Reset SQL Account Password

Getting Started #

The SQL Account passwords can only be reset in SQL Server Management Studio (SSMS). You can access SSMS two ways.

• Download it from Microsoft using the link below
  • https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
• AVD Remote Desktop (Cascade)

Reset Password #

One you have access to SSMS, you will connect to the same Server that you do with TAD.

Once connected, expand Security –> Logins

If you only see two accounts like the image below then you don’t have the correct permissions. Submit a support ticket to Trimble with a subject of “Please assign the securityadmin server role to SQL Account <your_account>.”

If you see a long list of accounts then you should have the correct permissions.

Double-click on the SQL Account that needs a password change.

Change both password fields and click the OK button.

The password has now been changed and the user can try again.