What is the sa (SQL admin account) password for the vRanger database (video) (4043588)

Installing/upgrading vRanger and customer does not remember the 'sa' (SQL admin account) password.

vRanger configured to use SQL authentication to connect to the database

The 'sa' password is set up by the user upon initial installation of SQL Express (part of the vRanger installer). This password is not stored within vRanger.

Steps to reset the 'sa' password

1. Download and install Microsoft SQL Server Management Studio Express.
2. Launch SQL Express Management Studio
3. Connect to the <servername>\VRANGERPRO instance using Windows Authentication

• where <servername> is the IP address or servername of the SQL Express computer (usually the vRanger computer)
• the logged on account should have local administrator access to the SQL Express computer

4. Expand Security -> Logins
5. Right click on the 'sa' account and select Properties from the menu
6. In the General Page, enter and confirm the new password
7. Re-run the vRanger installer and in the Database Wizard, select SQL Authentication and use the 'sa' account and the new password

If you are unable to reset the SA password via the SQL Express Management Studio the SA password can also be reset via the Command Prompt
1. Open command prompt
2. Type osql -S <servername>\VRANGERPRO –E
a. 1> sp_password NULL,'new_password','sa'
b. 2> go

To unlock the SA account:
1. osql -S <servername>\VRANGERPRO -E
a. 1> ALTER LOGIN sa WITH PASSWORD = 'new_password' UNLOCK
b. 2> go