CODEWITHSUNDEEP
c#connection-string
3vge
3vge

Reputation: 197

Connect other server database

I have a console app and want to connect other windows server where I have already created user, database table. In conf.xml I have 

<configuration>
  <crypto location="172.16.10.34" database="Crypto_Pan" username="PinbySms" password="ASDasd123"/>
</configuration>

then my code is :

Dictionary<string, string> d = conf.getCrypto();

SqlConnectionStringBuilder bu = new SqlConnectionStringBuilder();

bu.DataSource = d["location"];
bu.NetworkLibrary = "DBMSSOCN";
bu.InitialCatalog = d["database"];

bu.IntegratedSecurity = false;
bu.UserID = d["username"];
bu.Password = d["password"];
SqlConnection thisConnection = null;

try
{
    thisConnection = new SqlConnection(bu.ConnectionString);
    thisConnection.Open();
    Console.WriteLine("success connected");
}
catch (Exception e)
{
    Console.WriteLine("exeption: " + e.ToString());

    thisConnection.Close();

}

I have an error when my app try to connect this database:

[System.Data.SqlClient.SqlException] = {"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

Does anybody have any suggestions?

Upvotes: 0

Views: 135

Answers (1)

3vge
3vge

Reputation: 197

there was not default port in sql configuration PROTOCOL MSQSQLSERVER TCP/IP , i changed it to 1433 and now it's ok.

Upvotes: 1

Related Questions