sql server allow remote connections

11. Windows Firewall ->Advanced Settings->Inbound Rules
2
3Add a rule to enable TCP port 1433 (default port for SQL Server)
4
52. Run SSMS (SQL Server Management Studio) on SQL Server machine
6
7Server Properties -> Security -> SQL Server and Windows Authentication mode (Enable)
8
93. Server Properties - > Connections -> Allow Remote Connections ..” should be checked
10
114. Add a SQL login (if not already there)
12
13 5. Enable SQL Service to listen on TCP/IP
14
15Check SQL Server version and run appropriate version of SQL Configuration Manager to enable TCP.
16
17