I don't know the password for my SQL Server account (sa)

Overview

TimeTracker RX uses Microsoft SQL Server as its database.
The password for the SQL Server administrator account (sa) is specified during SQL Server installation, but
This document explains how to set the password if you have forgotten it.

info

If you installed SQL Server from the TimeTracker RX installer,
The password is "Administrator///".

Steps to Change the Administrator Account Password

1. Log in to Windows with a user account that has Windows administrator privileges.

2. Launch [System Tools] - [Command Prompt] from the Start Menu.

3. Execute the following command.

   sqlcmd -S server_name\instance_name -E

   • Server_name: The name of the server where SQL Server is installed
   • Instance_name: If SQL Server was automatically installed from the TimeTracker RX installer, it will be "SQLEXPRESS"

4. Execute the following command to change the password for sa.

   sp_password @new = 'new_password', @loginame= 'sa'<br/>
   go

5. Execute the following command to log out of SQL Server.

   exit

After the above steps, you will be able to log in to SQL Server with the newly set password.