When logging into a DNA Console that has been installed on a separate machine to the DNA Server, the following error message may be displayed when the connection to the SQL Server that hosts the NetSupport DNA database is attempted:
SQL Server does not exist or access denied. (ConnectionOpen (Connect())
The most common cause of this message is that the Windows Firewall on the SQL Server machine is blocking the connection attempt.
When the DNA Console login process takes place, there are two connections made from the DNA Console machine:
- A connection to the DNA Server.
- A connection to the SQL Server that hosts the NetSupport DNA database.
To resolve the connection issue, additional Windows Firewall rules need to be created on the SQL Server machine.
Below is the link to the Microsoft Technet article that details how to run wf.msc and then add the C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Sqlservr.exe application to the Windows Firewall rules:
This article is for SQL Server 2012 (32bit) that is installed with NetSupport DNA. Additional SQL Server version instructions (SQL Server 2014 and 2016) can be viewed.
The page also contains information on adding an Inbound Rule for the TCP 1433 port (the default port for SQL Server connections). In addition to this rule, you may also need to add an Inbound Rule for the UDP 1434 port number used by the SQL Server Browser service.