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
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
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.