When installing a standalone NetSupport DNA Console onto a workstation, several pre-requisites must be met to allow the DNA Console to connect to the DNA Server and the SQL Server the DNA database is hosted on.
- If the DNA database is hosted on any version of SQL Server 2008, 2012, 2014, 2016 or 2017, the Microsoft SQL Server Native Client will need to be installed on the machine the DNA Console is installed on.
The Microsoft SQL Server Native Client is available as a free download from the Microsoft website.
- The ServerName entry in the DNA Server registry (location below) must be in the [ServerName]\[SQLInstance] format to allow the DNA Console to connect to the SQL Server that is hosting the DNA database.
32bit HKEY_LOCAL_MACHINE\SOFTWARE\NetSupport Ltd\NetSupport DNA\Database
64bit HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\NetSupport Ltd\NetSupport DNA\Database
For example, if you are using a default SQL Server Express installation, the ServerName entry would be [ServerName]\SQLEXPRESS
- The SQL Server must be configured to allow remote connections from other machines on the network. The required SQL Server Configuration Manager settings are shown in Configuration of Microsoft SQL Server Express.
- The user can now run the DNA Console on their workstation and log in with their Operator user name and password.
This article is advising you to modify the registry, and you do so at your own risk. Serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow the steps carefully. For added protection, back up the registry before you modify it.