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:

Leave a Reply

%d bloggers like this: