Skip to main content

SQL Server setup

SQL Server port

1433 is a default port. Below, it is assumed that 1433 is used, but that may of course be changed. 

Assert that you're running SQL Server on port 1433, that the service is running and that you don't have a firewall blocking incoming connections. So, really check that TCP/IP protocol is enabled in your local SQLEXPRESS instance:

  • Open "Sql Server Configuration Manager"
  • Expand "SQL Server Network Configuration"
  • Go to "Protocols for SQLEXPRESS"
  • Make sure that TCP/IP is enabled
    • image.png

  • Port settings:
    • image.png

SQL Server browser

https://learn.microsoft.com/en-us/sql/tools/configuration-manager/sql-server-browser-service?view=sql-server-ver16

Another point to check might be the whether the SQL Server Browser service is running: 

image.png