Password recovery for "Owner" or sa user

Instructions for restoring access to the Torgsoft program for the main program user «Owner» with login sa.

When it is necessary

Applied in cases where the password for the main program account is lost, the standard login password does not work, and work in the program is blocked due to the inability to authorize.

Signs of the problem

Inability to authorize in the program under the user «Owner».

System message about incorrect login or password when attempting to sign in.

Database access error due to loss of the system administrator password (sa).

Requirements for self-resolution

For most technical reset methods, physical or full remote access to the server (main computer) with Windows Administrator rights is required.

Important: if you are working on a rented server without Administrator rights, a manual reset is impossible. In this case, contact the hosting system administrator or Torgsoft technical support immediately.

What to do

Option 1. Checking the standard password

By default, the password for logging in under the «Owner» user in the Torgsoft program is 2009. Enter it. If the password did not work, proceed to the following steps.

Option 2. Logging in via another user

If another user with administrator rights (without access restrictions) has been created in the database:

Go to profile settings and change the password for the «Owner» user.

Option 3. Resetting via SQL Server Management Studio

If access to the program is completely lost:

Open SQL Server Management Studio on the main computer (server).

Authorize using Windows Authentication.

In the Security -> Logins section, find the user sa or another required database user.

Change the password through the profile properties.

Option 4. Changing the sa password via command line (osql)

If Management Studio is unavailable, use the command line:

Run Command Prompt (cmd) or PowerShell as Administrator.

Enter the command to view available MS SQL servers:

osql -L

Connect to the required server (replace server_name with yours):

osql -S server_name -E

Execute the SQL query to change the password (replace new_password with yours):

sp_password NULL, <insert_new_password_here>, ’sa’

Type GO and press Enter.

Note: if you see the message Password validation failed..., it means the password is too simple. Set a more complex password that complies with Windows security policies (including capital letters, numbers, and symbols).

Option 5. Contacting technical support

If none of the methods helped or you do not have rights on the server:

Download and run the remote access program TeamViewer (file TeamViewerQS.exe).

Provide the generated ID to a Torgsoft specialist. The specialist will connect remotely and reset the password via the service registry or SQL Studio.

How to check the result

Launch the Torgsoft program, select the «Owner» user, and enter the new password. The login should be successful without any access error messages.

Prevention

Create a backup user in the program with administrator rights, whose password only you will know.

Securely store the password for the sa user, as it is key to managing the database.

Summary

To reset the password on your own server, use SQL Server Management Studio or the osql command. If the server is rented and you do not have administrator rights, contact technical support immediately.

Програма обліку товару для інтернет-магазинів, крамниць, торгових точок, складів та виробництва

Thank you for your feedback! It will be published after being reviewed by a moderator.

Last name and first name
Phone number
Other contact information
Database type
Do you need a call and consultation from a company employee? Yes No Choose one of the options
I agree with Torgsoft's Privacy Policy. Please review Torgsoft's Privacy Policy. If you agree, please confirm below.

Last name and first name

Phone number

Other contact information

Database type

Do you need a call and consultation from a company employee?

Yes

Choose one of the options

I agree with Torgsoft's Privacy Policy.

Please review Torgsoft's Privacy Policy. If you agree, please confirm below.