Connection String issue in ASP.NET

Question

I am unable to connect to my database to insert data into it.

protected void Submit_Click(object sender, EventArgs e)
{
    using(SqlConnection sc = new SqlConnection()) {
    sc.ConnectionString = "Data Source=localhost;Initial Catalog=DrugDB;Integrated Security=True";
    sc.Open();
    using (SqlCommand com = sc.CreateCommand()) {
        com.CommandText = "insert into Drug(DrugID,DrugName)values(@txtDrugID,@DrugName)";
       com.Parameters.Add("@DrugID", SqlDbType.VarChar, 10).Value=TBDrugId.Text;
       com.Parameters.Add("@DrugName", SqlDbType.VarChar, 10).Value=TBDrugName.Text;
}
    }

This is the error I get:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

This in in my webconfig:

<connectionStrings>
<add name="DrugDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=DrugDB.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
<add name="ApplicationServices" connectionString="data source=SOIS-PC\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=testdatabase.mdf;User Instance=true" providerName="System.Data.SqlClient" />
<add name="ConStr" connectionString="Data Source=SOIS-PC\SQLEXPRESS;AttachDbFilename=DrugDB.mdf; Integrated Security=True"/>
</connectionStrings>

Plase help!!!

Are you sure the user is allowed to connect to the server ? Can you try connecting to the DB using SQL management studio ? — Luc Morin
– Luc Morin, Commented Mar 18, 2014 at 5:03
It is still erroring out! <add name="ConStr" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Users\SOIS\Documents\Visual Studio 2010\WebSites\DummyPharmacy\App_Data\DrugDB.mdf"; Integrated Security=True;User Instance=True"/> </connectionStrings> It says missing required whitespace Expecting end tag /add — divinediu
– divinediu, Commented Mar 18, 2014 at 5:07
I created the DB using Visual Studio. I cannot attach the DB through my SQL server. I do not know why. — divinediu
– divinediu, Commented Mar 18, 2014 at 5:10

Community · Accepted Answer · 2017-05-23 11:49:47Z

1

It could be your SQL Server is configured to use NAMED PIPES instead of TCP/IP. Connect using TCP/IP, or use the SQL Server Configuration Manager to enable remote connections using named pipes. more info here

Also here is another post

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Mar 18, 2014 at 5:10

highwingers

1,6694 gold badges22 silver badges41 bronze badges

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

1 Comment

divinediu Over a year ago

Tried that. Restarting now.

Collectives™ on Stack Overflow

Connection String issue in ASP.NET

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related