personalizer connecting to sql server code example

Example: 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