| |

Unable to determine the TCP port number used by Microsoft SQL server ‘.\MSSQLSERVER2016

BySam
The warning “Unable to determine the TCP port number used by Microsoft SQL server ‘.\MSSQLSERVER2016′” indicates that the SQL Server instance is either not configured to use TCP/IP, or it is configured to use dynamic TCP ports. To resolve this and enable automatic firewall configuration for remote access, the SQL Server instance needs to be configured to listen on a specific, fixed TCP port.
Here are the steps to configure a fixed TCP port for your SQL Server instance:
  • Open SQL Server Configuration Manager:
    • Press Windows Key + R to open the Run dialog.
    • Type SQLServerManager13.msc (for SQL Server 2016) and press Enter.
  • Enable TCP/IP Protocol:
    • In SQL Server Configuration Manager, expand SQL Server Network Configuration.
    • Click on Protocols for MSSQLSERVER2016 (or the name of your specific instance).
    • In the right pane, right-click on TCP/IP and select Enable if it’s not already enabled.
    • Configure a Fixed TCP Port:
      • Right-click on TCP/IP and select Properties.
      • Go to the IP Addresses tab.
      • Scroll down to the IPAll section.
      • In the TCP Dynamic Ports field, ensure it is empty. If it contains 0, delete it.
      • In the TCP Port field, enter a specific port number (e.g., 1433, which is the default SQL Server port). Ensure this port is not in use by another application.
      • Click OK.
  • Restart SQL Server Service:
    • In SQL Server Configuration Manager, go to SQL Server Services.
    • Right-click on SQL Server (MSSQLSERVER2016) and select Restart.
  • Configure Windows Firewall:
    • Open Windows Firewall with Advanced Security.
    • Create a new Inbound Rule to allow connections on the TCP port you configured (e.g., 1433) for the SQL Server executable (sqlservr.exe).
After completing these steps, the SQL Server instance will be listening on the specified fixed TCP port, allowing for easier firewall configuration and remote access.

Similar Posts

How to run a PHP script using a custom PHP executable in Plesk Scheduled Tasks?

BySam

https://support.plesk.com/hc/en-us/articles/12377377419287-How-to-run-a-PHP-script-using-a-custom-PHP-executable-in-Plesk-Scheduled-Tasks- Log into Plesk. Go to Tools & Settings > Scheduled Task > Add Task; At Script Path, specify the full path to the PHP script on the server. If arguments are needed, specify that accordingly in the with arguments field; At Run field, specify the desired frequency the task should be run; Choose the Run a PHP…

Get current plesk admin password or reset plesk admin password

BySam

Retrieving the current Plesk administrator password depends on the operating system and Plesk version. For Windows servers: Connect to the server via Remote Desktop. Open Command Prompt: From the Start menu, select “Run…” and type cmd. Navigate to the Plesk bin directory: Code cd “C:\Program Files (x86)\Plesk\admin\bin” (Note: The path might vary slightly depending on…

| |

How can I BACKUP a MySQL database from the command line?

BySam

Performing a MySQL Database Dump From your SSH command prompt type … mysqldump -u {username} -p {password} {databasename} > {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql} – the file to…

| |

How can I RESTORE a MySQL database from the command line?

BySam

Importing a MySQLDUMP From your SSH command prompt type … mysqladmin -u {username} -p {password} create {databasename} mysql -u {username} -p {password} < {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql}…