0

after installing the SQL Server Update KB4505224 this weekend, I’m no longer able to connect to the SQL server from the network. On localhost it still works.

If I disable the windows firewall entirely it works again. Are there any known issues with this update?

My firewall rules look like this:

  • Allow everything for %ProgramFiles%\Microsoft SQL Server\MSSQL14.MYSQLSERVER\MSSQL\Binn\sqlservr.exe
  • Allow TCP and UDP for 1433 and 1434

The SQL Server uses dynamic ports.

Thanks.

1

Please download and install Cumulative Update 17 from this URL.

After installing CU17, make sure you have configured Windows Firewall as stated on this documentation.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.