sql manager conect to ip
Configure SQL Server machine
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.
6. Restart SQL Server Service 