1542 - How to edit the AccountServer's ConnectionStrings.config file when upgrading the Storage Platform to v24.5

Storage Platform v24.5 contains a fix to enable recognition of newer certificates used to sign client updates. For this to take effect, you will need to edit the AccountServer's ConnectionStrings.config file as below before installing v24.5.

To edit the ConnectionStrings.config file:

1. Stop the 21.7 AccountServer service.

2. Locate the file ConnectionStrings.config in the Storage Platform installation folder (default location C:\Program Files\Attix5 Pro\Storage Platform\) and make a copy of the file as a security measure.

3. Add the following to the end of the connection string for each database:

;TrustServerCertificate=True

For example, if the file originally contained the entry

connectionString=";Password=Password123;Persist Security Info=True;User ID=sa;
Initial Catalog=StoragePlatform;Data Source=PHDRAS\SQLEXPRESS"

this entry will now be

connectionString=";Password=Password123;Persist Security Info=True;User ID=sa;
Initial Catalog=StoragePlatform;Data Source=PHDRAS\SQLEXPRESS;TrustServerCertificate=True"

4. Save the file. The 21.7 AccountServer service will not start after this point.

5. Run the new Storage Platform installer (24.5.31.11249). The AccountServer service should run correctly after the upgrade.

Note: Attempting to run reports as the ?admin? user will not work after this update, as it includes security improvements that prevent this. Storage Platform reports will now need to be run as a different user, so you may need to create a Classic User if you want to run reports.