I'm trying to purge some historical data from our CCM Database to get a bit of control over the size and have downloaded the correct version of the "purge historical data" tool (6-7).
I've tried running it but get the error System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.
I have domain admin rights and full DB permissions.
I've not seen anything about applying any config to the software.
Has anyone any experience with this software and seen this error before or have any recomendations?
Alternatively are there any scripts that do the same thing?