Connect remote to database C#

Change your connection string to  connectionString= "data source = System Ipaddress,1433Initial catalog = *****, User ID = sa, Password=*****"

 

and make sure the system has port open and firewall rule is set for the 1433 port. 

Hi Goran,

 

You just need to change you connection string in web config file with Server ip address as

Datasource and Initial catlog with your database name. thats it. no other changes require. 

Hello Goran Bibic,

 

         I have read you question. If you want to connect other location database, you need to your static ip address. base on Static ip addres you want to connect your other location pc database MS SQL Server 

You can connect using connection string in web.config file. 

 

Add IP address in data source like

Data Source=10.22.5.20,1433 

 

example: