t-sql enable remote connections code example

Example: sql server allow remote connections

1. Windows Firewall ->Advanced Settings->Inbound Rules

Add a rule to enable TCP port 1433 (default port for SQL Server)

2. Run SSMS (SQL Server Management Studio) on SQL Server machine

Server Properties -> Security -> SQL Server and Windows Authentication mode (Enable)

3. Server Properties - > Connections -> Allow Remote Connections ..” should be checked

4. Add a SQL login (if not already there)

 5. Enable SQL Service to listen on TCP/IP

Check SQL Server version and run appropriate version of SQL Configuration Manager to enable TCP.