How to resolve database connection string problems in asp.net?

Question

I am developing an asp.net mvc3 application using Visual Studio 2010.I need to access the database. I wrote the connection string as

SqlConnection conn = new SqlConnection("Data Source=./App_Data/Abcd.mdf;Integrated Security=True;User Instance=True");

But, when I run the code, I get an error: 40 - Could not open a connection to SQL Server.

From the SQL Server Configuration Manager, I enabled TCP/IP but I still get the same exception.

I also tried changing the connection string to

SqlConnection conn = new SqlConnection("System.Configuration.ConfigurationManager.ConnectionStrings.ConnectionString");

But I got an exception that said "Format of the initialization string does not conform to specification starting at index 0."

How do I overcome this problem?

Thank you in advance for your help.

Are you using SQL Developer/Standard, or SQL Express? Can you connect using SSMS? — RickNZ
– RickNZ, Commented Jan 3, 2012 at 10:33

Darin Dimitrov · Accepted Answer · 2012-01-03 13:16:45Z

1

This will depend on the type of database you are using: SQL Express or SQL Developer/Standard. If you use SQL Express you may take a look at the following article illustrating different connection strings. For example:

Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|Abcd.mdf;Integrated Security=True;User Instance=True

If you are using the full version of SQL Server, your database is no longer stored in the App_Data folder. It is managed by SQL Server. Checkout the following site for connection strings in this case depending on your scenario.

Example:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

answered Jan 3, 2012 at 13:16

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

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

Comments

Meysam Savameri · Accepted Answer · 2012-01-03 09:58:18Z

0

SqlConnection conn = new SqlConnection("Data Source=.\sqlexpress;database=dbname;AttachDbFilename=|DataDirectory|\Abcd.mdf;Integrated Security=True;User Instance=True");
or
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("webconfigconnectionname").ConnectionString);

answered Jan 3, 2012 at 9:58

Meysam Savameri

5562 gold badges13 silver badges33 bronze badges

Comments

Lijin Durairaj · Accepted Answer · 2014-09-04 19:34:26Z

0

In VS click on server explorer and add the connection when the connection has been setup right click on the established connection and select properties you will get the properties window open. In that window select the connection string, which you can use in the sqlconnection

answered Sep 4, 2014 at 19:34

Lijin Durairaj

5,26815 gold badges63 silver badges96 bronze badges

Collectives™ on Stack Overflow

How to resolve database connection string problems in asp.net?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related