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 a Microsoft article that details how to run wf.msc and then add the required Windows Firewall rule to allow access the SQL Database:
This article is for different versions of SQL, NetSupport DNA installs with SQL 2019 (64bit) and the Windows Firewall rule for this version would be the following :
C:\Program Files (x86)\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\Sqlservr.exe
The path to the above file may differ for different versions of SQL as explained in the Microsoft article.
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.