SQL Server Configuration Manager

SQL Server network configuration TCP to open

Connection Test Open with Microsoft SQL Server Managerment Studio tcp:hostname/databasename,Port

SQL Server Default Port: (TCP) 1433

The firewall remembers to whitelist the port

reference document

http://dog0416.blogspot.com/2020/07/sql-server-reporting-service-20172019.html

https://blog.alantsai.net/posts/2017/11/sql-troubleshooting-guide-mssql-connection-problem

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15