3.4.3
Configuring the SQL Server 2016 with remote database
The following example is a description of the "SQL server 2016" configuration with remote
database.
Prerequisite
You require administrator rights in the database, e.g. authorization level user "Sysadmin" as
"Domain/Local User" or as SQL user (sa).
Procedure
1. Open the "SQL Server Configuration Manager".
2. Open "SQL Server Network Configuration" and select "Protocols for".
The status is shown in the right window area.
3. Open the properties for "TCP/IP", and check whether the Firewall is configured with the
permitted port 1433.
Installing/configuring Windows services
3.4 SQL Server 2016
Manage MyResources, Optimize MyProgramming /NX-Cam Editor
58
Installation Manual, 12/2019, A5E44672080B AE