MSSql server connection failed

Question

I am trying to connect to an MS SQL server residing on our local network but always

getting back the message of "System.Data.SqlClient.SqlException(0x80131904): A network-related or instance-specific error occurred...".

I can connect to the server with TOAD for SQL SERVER by Windows authentication.

I copied the code below.

What did I do wrong.

private void button1_Click(object sender, EventArgs e)

{

SqlConnection conn = new SqlConnection("server=\\AAA"

+ "trusted_connection=yes;"

+ "database=TESZT;connection timeout=10");

try

{

conn.Open();

label1.Text = "Connection OK";

conn.Close();

}

catch(Exception ex)

{

label1.Text = ex.ToString();

}

Thanks,

Tamas

Tamas Szigeti · Answer

Interestingly enough when I try to connect to the same database by Data Source Configuration Wizard it works. Here is the connection string from the wizard: Data Source=AAA;Initial Catalog=teszt;Integrated Security=True. Why does not work it with this line of code then? SqlConnection conn = new SqlConnection ( Server=AAA; Database=teszt;Trusted_Connection=True );

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/uploadfile/abhikumarvatsa/connecting-to-sql-server-in-Asp-Net/default.aspx

Javeed M Shaikh · Answer

try this connection string: SqlConnection conn = new SqlConnection(Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;);