I just upgraded our Connections environment from 4 to 4.5. Unfortunately it didn’t run as smoothly as expected.
I did a side-by-side migration (no application artifacts export) and copied all content stores to the new server
A really nasty problem was that all activities file uploads could not be accessed after the upgrade 🙁
Just tried to create the Cognos BI DB’s on my Connections 4 DB server, I ended up getting a error:
No authorized routine named “COLLATIONNAME” of type “FUNCTION” having compatible arguments was found. SQLSTATE=42884
Quick googling helped me to remind myself to ALWAYS disable Sophos on the server, even if I only want to create some DB’s:
Looks like I will have a busy weekend: