This article describes how to configure the Windows Firewall to allow SQL Server access if the ODBC connection fails.
Firewall systems help to prevent unauthorized access to computer resources. If a firewall is turned on but not correctly configured, attempts to connect to the SQL Server might be blocked.
Known to apply to the following Sophos product(s) and version(s)
SafeGuard LAN Crypt Administration
What To Do
To access an instance of the SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server. The firewall is a component of Microsoft Windows.
Details of how to open a port to allow access to the SQL Server are provided on the Microsoft website: http://msdn.microsoft.com/library/cc646023.aspx