Update SQL Database Passwords

During the Revolution installation, you entered write/read passwords for the SQL database. If you need to change those passwords, follow these instructions.

Important: Run these commands as an administrator.

  1. Log in to the Revolution server.
  2. Shut down the Revolution services.
    1. Run the Microsoft Service Manager tool (services.msc).
    2. Find the Revolution services, where the Names all start with Syn-Apps.
    3. Right-click on each Syn-Apps service and select Stop.
  3. Update the SQL database passwords.
    1. Run the Microsoft SQL Server Management Studio tool.
    2. Expand Security > Logins.
    3. Right-click on both Syn-AppsReadOnly and Syn-AppsWrite and select Properties.
    4. Update the Passwords.
  4. Open a command line prompt.
    1. Change directories to Program Files (x86)\Syn-Apps\SAAnnounceRevolution.
    2. Run DBInfoUpdater.exe -write Syn-AppsWrite [new password] -read Syn-AppsReadOnly [new password].
  5. Restart the UnifiedGui website
    1. Run the Internet Information Services (IIS) Manager.
    2. Under Sites, select UnifiedGUi
    3. In the Actions panel, on the right, select Restart.
  6. Restart the Revolution server.

The Revolution SQL write/read passwords are now updated.