Flex2SQL Migration Tool Login Failure

An error message was reported attempting to connect to an SQL server from the Flex2SQL Migration Tool:

The reported problem was traced to a firewall setting. The following troubleshooting steps are suggested if this problem occurs.

Verify that the required services are running

1. Start the Control Panel then select Administrative Tools > Services.
2. The status for the SQL Server <Instance> and SQL Server Browser should be Started.

Check your version of SQL Server Native Client

1. Start SQL Server Configuration Manager.
   
   
2. SQL Native Client nn Configuration is listed in the left panel.
   Note: The Microsoft SQL Server Native Client version can also be found in the registry under HKEY_LOCAL_MACHINE > SOFTWARE > Microsoft

By default the Mertech driver looks for Microsoft SQL Server 2012 Native Client and then falls back to version 2008 or 2005 if version 2012 is not available.

- Microsoft SQL Server Native Client 11.0 is installed when you install SQL Server 2012

- Microsoft SQL Server Native Client 10.0 is installed when you install SQL Server 2008

- Microsoft SQL Server Native Client 9.0 is installed when you install SQL Server 2005

Check that you are using the correct server name or IP address

- If you are using the server name make sure the DNS Manager is able to resolve your server name.

Determine if a firewall is blocking the connection to the server

- Examine firewall rules to determine if a connection to the server is allowed. If logging is turned on, examine the firewall the log file.