Versions Compared

Old Version 4

changes.mady.by.user ahmet.boran.old (Deactivated)

Saved on

compared with

New Version 5

changes.mady.by.user Andrew Paydon

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

With encryption forced on the SQL Server it is critical that a trusted and current certificate is maintained on the server. After the certificate expiry the server will stop accepting connections until the certificate is replaced with a new one, so proactive certificate management should be scheduled to replace the certificate ahead of the expiry and avoid any outages.

Testing

Set up on HERA3\DevTest for v70

ProgramsTestsComments
SynMain
  1. Accessed Maintenance Programs
  2. Executed basic functionality (incl. Finance)

SynWeb
  1. Accessed Maintenance Programs
  2. Executed basic functionality (incl. Finance)

Community Portal
  1. Accessed pages
  2. Executed some functionality

Form Builder
  1. Copied form
  2. Published form
  3. Submitted form (Application received in SynMain)

Online Event Booking
  1. Completed through to paid event

SADT
  1. Signed In/Out (data correct in SynMain)

SSRS
  1. Ran finance/non-finance report

SynAPI

SynWeb Services

Service Suite

Core APIHas been utilised through testing (e.g. Form Builder/Payments)
Application Portal

DB PatcherDatabase has been patched without error
Crystal Reports

Study PeriodAccessed and checked in Student
SIF

Power BI

Finance & Non-Finance report produces correct data


Reference articles

https://blog.coeo.com/securing-connections-to-sql-server-with-tls

...