Error creating Connections 4 DB’s – Oh Sophos! How do I love thee..
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: