Issue

If you do not know the password to the Breeze 'Database User', you can run the Microsoft SQL Server 'sp_password' command to change the password. However, you need to be logged onto the SQL Server as 'sa'. If you do not know the 'sa' password, you can run sp_password from the Windows command line if you are logged onto the computer as an Administrator.

Solution

osql -E -d master -Q "EXEC sp_password @new='newpassword', @loginame ='login-name'"

The "-E" parameter is the Trusted Connection option where it will use the Windows Administrator credentials to run the SQL command. This allows you to run the command without having to be logged in as 'sa'. You will need to change 'newpassword' and 'login-name'.

Note: Once you successfully change the password, you will need to go to the Breeze Console (http://localhost:8510/console) and enter the new password. You can find the password field by going to Application Settings > Database Settings.

Watch the demonstration below for the steps to change the Breeze password without being logged in as 'sa'.

 

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy