- Named instances use dynamic ports by default; only the default instance uses 1433.
- SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for your instance > TCP/IP.
- On IP Addresses, under IPAll, clear TCP Dynamic Ports (remove the 0) and type 1433 (or another port) in TCP Port.
- Restart the SQL Server service.
- Open that port in the firewall. To connect by instance name instead, run SQL Server Browser.
MuADMINS biên soạn từ nguồnNot verified
Microsoft Learn · 2025-08-26