ADO.NET : Error occurred while establishing a connection to SQL Server

Question

i am trying to bind data to Gridview and getting this error

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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

this is my simple code

 string cs = "data source =.; initial catalog= MyDB;  integrated security= SSPI";
 SqlConnection con = new SqlConnection(cs);
 SqlCommand cmd = new SqlCommand("select * from tbl_Dept", con);
 con.Open();
 GridView1.DataSource = cmd.ExecuteReader();
 GridView1.DataBind();
 con.Close();

in SQl management studio i have rechecked db name and its same as mentioned in code

I found some related questions but those did not work for me so posting mine one , Please help me with it,

Perhaps you have typo. You have missed semicolon after DB name. — Hamlet Hakobyan
– Hamlet Hakobyan, Commented May 26, 2014 at 22:00
In Sql Server Management Studio what is the value of the Server Name textbox when you log in the database? — Steve
– Steve, Commented May 26, 2014 at 22:07

Amit Kumawat · Accepted Answer · 2015-10-31 07:48:57Z

2

You can define SqlConnection string in your web.config(in web applications) or app.config(in windows form application). Simply define like this -

<configuration>
    <connectionStrings>
         <add name="Connection" providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;Initial   Catalog=DBName;Trusted_connection=yes;User ID=''; Password=''"/
    </connectionStrings>
</configuration>

then access this code in you .cs form using

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Connection"].ConnectionString.ToString());

and after this you can use SqlConnection object con in you whole form.

answered Oct 31, 2015 at 7:48

Amit Kumawat

6026 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Steve · Accepted Answer · 2014-05-26 22:19:04Z

1

When you install SQL Server Express the setup propose to create a named instance, and by default, this named instance, is called SQLEXPRESS.

When you want to connect to this named instance it is required to specify the name.
So, in your case your connection string should be changed to

"Data Source =.\SQLEXPRESS;Initial Catalog=MyDB;Integrated Security=SSPI";

answered May 26, 2014 at 22:19

Steve

217k22 gold badges242 silver badges296 bronze badges

Collectives™ on Stack Overflow

ADO.NET : Error occurred while establishing a connection to SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related