Hi All,
how to connect Remote SQL Server Database. through the internet using Public Static IP and Port Number..?
in remote machine. i am used SQL Server 2019.
i want to connect remote SQL Server Database. with using public static IP 126.158.2.125 and Port 50121.
from Local Machine.
i am created port with number 50121.
created firewall Rules also. like image at below.
in Windows defender firewall
TCP Inbound Rules.




UDP Outbound Rules.




Connection Local:
it's working fine.
used Connection string like at below.
Server Local Machine IP: 192.168.1.17 (sample)
Port Number: 50121.
SqlConnectionStringBuilder sqlConBui = new SqlConnectionStringBuilder();
sqlConBui.DataSource = @"192.168.1.17,50121\STUDENTMSSQLSERVER";
sqlConBui.InitialCatalog = "StudentDatBas";
sqlConBui.PersistSecurityInfo = true;
sqlConBui.MultipleActiveResultSets = true;
sqlConBui.UserID = "Student";
sqlConBui.Password = "Stu1234";
string connectionString = sqlConBui.ConnectionString;
try
{
SqlConnection con = new SqlConnection(connectionString);
con.Open(); // Open the connection
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
i want to Access SQL Server DataBase from Remote machine. through the internet.
with using public static IP Address and specific port number.
Remote Connection:
it's not working.
used Connection string like at below.
Public Static IP: 126.158.2.125 (sample)
Port Number: 50121.
SqlConnectionStringBuilder sqlConBui = new SqlConnectionStringBuilder();
sqlConBui.DataSource = @"126.158.2.125,50121\STUDENTMSSQLSERVER";
sqlConBui.InitialCatalog = "StudentDatBas";
sqlConBui.PersistSecurityInfo = true;
sqlConBui.MultipleActiveResultSets = true;
sqlConBui.UserID = "Student";
sqlConBui.Password = "Stu1234";
string connectionString = sqlConBui.ConnectionString;
try
{
SqlConnection con = new SqlConnection(connectionString);
con.Open(); // Open the connection
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
getting error.
like image at below.

Port Result:
SQL Server Image:


SQL Server Configuration Manager:




how i can do it..?.
can provie some code snippet..?.
with best Regards.
NazHim
