Resolve SPS Error: Cannot open database requested by the login

Use this article to resolve an error where one of the Synergize Process Server (SPS) processes generates an error similar to the example shown below during a workflow iteration. The server hosting the deployment database is unavailable or the account used to connect to the database has been altered. Possibly a password change or deletion of the account might also contribute to this error.

You might get the following error message:

There was an error connecting to the Activity Log database.
Please check the connection string.

Graphical user interface, text, application, email Description automatically generated

1. Verify the Microsoft SQL account still exists and the credentials for the account.

2. On the server hosting SPS Designer navigate to the Synergize Process Server\bin folder.

In the folder open the clientsettings xml file in notepad.

Graphical user interface, text, application, email Description automatically generated

3. Update the Data Source with the new SQL server instance and save.

3. In the bin folder launch Synergize Encryption as admin.

Graphical user interface, text, application, email Description automatically generated

Type the new password in the textbox and click the green arrow. Copy the text generated in the encrypted textbox.

Graphical user interface, text, application Description automatically generated

paste the text between the pipes in the clientsettings xml then save.

Graphical user interface, text, application, email Description automatically generated

Note: If there is another instance of the clientsettings xml file in the Synergize Process Server parent folder repeat the copy and paste steps.

4. Restart the SPS service as instructed in the article below.

https://support.microdea.com/hc/en-us/articles/208318377-How-to-Restart-SPS-Service-manually

Note: If there are SPS processes that connect to SQL databases using the modified SQL account contact Microdea support to update the action.