Skip to content Skip to sidebar Skip to footer

Sql Server 2017 Developer Edition Not Connectable

I installed SQL Server 2017 Developer Edition but its not starting any network server. There is nothing listening on the default SS port (1433). I cannot connect to it with any db

Solution 1:

The answer is that 2017 Dev Edition acts like the Free Edition and uses random ports. But you can change it. See link below. Argh! How to Configure SQL Server to Use a Specific Port

Solution 2:

The only required steps are:

  1. Enable TCP/IP in the SQL Server Configuration Manager.
  2. Restart SQL Server
  3. Open the Windows Firewall

The SQL Server log will record the IP address and port it is listening on during startup with an entry like:

Server is listening on [ 'any' <ipv6> 1433].

Post a Comment for "Sql Server 2017 Developer Edition Not Connectable"