Finding or resetting the password for Recipe Editor and Recipe Viewer.

Sometimes you will need to find out the password to access the Recipe Viewer.

This information can be obtained by accessing the SQL server that is hosting the Recipe.Portal, and Recipe.system databases.

 

To find out the Recipe Viewer user and password you can follow these steps.
a) Find out the Recipe.Portal database that is running the Recipe Portal application

b) Once you have found the Recip.Portal database, open the Tables section.
c) In the table section, search the dbo.Users table, and proceed to right click on it, and select the Edit top 200 Rows.
d) The table content will display, and you will be able to see the the password under the column of the same name, and the user information will be found under the Email column.

 

To find out the user and reset the password in the Recipe Editor application, you can follow these steps.

a) Find out the Recipe.System database that is running the Recipe Editor application
b) Once you have found the Recip.System database, open the Tables section.
c) In the table section, search the dbo.Security.Users.Accounts table, and proceed to right click on it, and select the Edit top 200 Rows.
d) Once the table is opened, search under the UserPass column for the following entry "cGFzc3dvcmQ=", this entry equals the word "password", you can copy and paste this entry into the field corresponding to the user who needs to access the Recipe Editor.