String connection to remote server

Question

Hello, everyone,

I have a question about how to connect a .NET application (programmed in C#) to a database (BaseX) of a SQL Server instance (ServerX) through a SQL user (Usser: UserX, Password: PasswordX) located in a remote server which can be accessed through a remote connection (IP: 193.160.160.240, user: UserZ, password: PasswordZ).

If I run the application from the server itself or a computer located in the network that has access to the server, the connection I make is as follows:
SqlConnection cn;
cn = new SqlConnection(Data Source=ServerX; Initial Catalog=BaseX; User ID=UserX; Password=PasswordX);

How should I specify in the connection string that remote connection to the server where the database is located?

Thank you.

Answer 1

The connection string for connecting to a remote SQL server is generally written as:

Data Source=ip,port;Network Library=DBMSSOCN;Initial Catalog=BaseX;User ID=UserX;Password=PasswordX;  

If you haven't modified the port, you don't need to write it.

This is not very different from the connection string you are using. Have you encountered any problems?

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You address the server name, so as long as network server name resolving work, that connection string works for local as well as for remote connections.

Answer 3

Hi

if (Settings.Default.ServerMode == "SQL")
   {
string strcnn = "Data Source=192.168.100.215,1433; Network Library=DBMSSOCN;Initial Catalog=YourDB; User ID=YourUserName;Password=YourPassword";

IDbConnection con = new SqlConnection(strcnn);

con.Open();

  return con;
}

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support.