Troubleshooting - Password Reset

Application Reset | Database Reset

There are two ways you can reset a user's password in Visual Casino. One method can be done through the application interface. If all users have lost access to the application, you can set a user's password directly from the database server.

Reset using Application

1. Log in to Visual Casino as a user with the User Management: Reset a User's password permission
2. Select Administration > User Manager...
3. Double Click on the user whose password you wish to reset
4. Locate the password fields in the lower half of the dialog
5. Enter the new password for the user in both fields
6. Check the box next to User Must Change Password at Next Logon
7. Click OK

Reset using Database

Use the following code to create a password; you will need to replace XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX in two locations with the user's UserGUID in UPPER CASE format and change NEW_PASSWORD to the password you wish to use:

UPDATE dbo.Users
 SET [PassPhrase] = (SELECT
   CAST(N'' AS XML).value(
   'xs:base64Binary(xs:hexBinary(sql:column("binn")))'
   , 'VARCHAR(MAX)'
   ) Base64Encoding
  FROM (
   SELECT CAST(HASHBYTES('SHA2_256', '{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}' + (SELECT
     CAST(N'' AS XML).value(
     'xs:base64Binary(xs:hexBinary(sql:column("bin")))'
     , 'VARCHAR(MAX)'
    ) Base64Encoding
   FROM (
    SELECT CAST(HASHBYTES('SHA2_256', + 'NEW_PASSWORD') AS VARBINARY(MAX)) AS bin
   ) AS bin_sql_server_temp)) AS VARBINARY(MAX)) AS binn
  ) AS bin_sql_server_temp_pass_hash),
  [MustChange] = 1
 WHERE [UserGUID] = 'XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX';