Sophos PureMessage 3.1.3 "No SQL Server has been found"

Hello All

I encountered extremely annoying error when installing Sophos PureMessage latest release. Issue attached.

Issue

 Cannot find the SQL server local instance.

Resolution

1.       When installing SQL server Express Edition ( Sql 2008 upwards) change the Named instance from “SqlServerExpress” to SOPHOS.

2.       Enable TCP/IP in protocols for the SOPHOS instance using SQL Configurator.

3.       Change the dynamic ports to 1433 then restart “SQLServer(SOPHOS)” service.

4.       Go through the install wizard and add the “Servername\SOPHOS” in the field and click next , if you click browse to find the local instance , it will still show the same error so disregard that step altogether.

5.       J and have a laugh and complete all the installation steps.

Cheers