Windows firewall can prevent V12 Visual LANSA network client from accessing SQL Server database

Date:28 May 2010
Product/Release:Visual LANSA V12
Abstract:To access an instance of the SQL Server Database Engine through a firewall, you must configure the firewall on the computer running SQL Server to allow access
Submitted By:LANSA Technical Support

Description:

If you have a firewall enabled in your windows environment (including the Windows shipped firewall) its possible that after a successful install of a V12 Visual LANSA network Client, when launching the IDE on the network client, you may encounter the following error:

[Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

This error is generated by the SQL Server database because the firewall is preventing unauthorized access to computer resources, in this case your SQL Server database. 

Solution:

To access an instance of the SQL Server Database Engine through a firewall, you must configure the firewall on the computer running SQL Server to allow access.

Use the following Microsoft Article to configure your firewall to allow Database Engine access http://msdn.microsoft.com/en-us/library/ms175043.aspx

Please note that both of the procedures listed under the following headings need to be implemented:

  1. To open a port in the Windows firewall for TCP access
  2. To access a program through the Windows firewall

Note: The checklist in the V12 Installing Visual LANSA on Windows guide contains this check:

Make sure the database is accessible from other machines and the User Id has access to the database.

This check can be tested in the following ways:

  • Make sure the database is accessible from other machines

    The best test is to try to create a DSN on the Client PC in the ODBC Administrator which points to the database of interest and use the TEST button to test the connection. If you encounter the error above, you will need to configure your firewall using the instructions in the MS article.
     
  • The User Id has access to the database

    A user needs to be added to the database security settings. This is a common requirement with database engines. If a user creates a new SQL Server Expresss database through the V12 Visual LANSA install, this user is automatically added to the database security so Visual LANSA can be used straight away. However, if other users are to have access then they must be added to the database security settings.