Database connection not working in ASP MVC

Question

I just create a new ASP MVC sample. The code was generate with scaffolding. Then I run the application and it runs smooth. But when I click "Register" link in top nav bar and tries to register it does not work.

My Connection String:

<add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-ProductExa‌mple-20151218101004.mdf;Initial Catalog=aspnet-ProductExample-20151218101004;Integrated Security=True" providerName="System.Data.SqlClient" />

Hello Emmad Zahid, It is saying that the Connection String is not proper. Please check your connection with sql server. — Nirav Kamani, Dec 18 '15 at 05:23
I am new to ASP MVC. But this is my connection string I havent changed it. — Emmad Zahid, Dec 18 '15 at 05:24
Please check in your AppData folder, Is there any file named aspnet-ProductExa‌mple-20151218101004.mdf. If not you need to add one. — Suprabhat Biswal, Dec 18 '15 at 05:28
No there is no database file. I have refreshed the view too. — Emmad Zahid, Dec 18 '15 at 05:29
See you have got your culprit. No database file then such kind of exception surely would raise. Kindly add one :) — Suprabhat Biswal, Dec 18 '15 at 05:32
I knew that there is no database file, but why it not creating database? All I want to know is what is the issue with connection string? I havent changed the string. It just comes with scaffolding. — Emmad Zahid, Dec 18 '15 at 05:33
Guys its working now. I just changed the connection string to and its working. I dont know why, can some one explain this to me? — Emmad Zahid, Dec 18 '15 at 05:44

score 0 · Answer 1 · answered Dec 18 '15 at 05:28

It is saying that your connection with sql server is not established.

Please check your connection string.

Here i am showing mine. Please check it once. It may help you.

<connectionStrings>
    <add name="DemoEntities" connectionString="metadata=res://*/Models.Report.DemoEntities.csdl|res://*/Models.Report.DemoEntities.ssdl|res://*/Models.Report.DemoEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=192.168.1.2\SQLEXPRESS;initial catalog=DEMODB;user id=abc;password=abc;multipleactiveresultsets=True;application name=EntityFramework&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

Check all following parameters are correct or not.

data source=192.168.1.2\SQLEXPRESS;

initial catalog=DEMODB;

user id=abc;

password=abc;

According to your sql server configuration you need to correct your connection string.

I needed to write IP\InstaceName may be in your you only need to write IP or only instace name. Please check it once.

I changed my string to and its working now.Can some one explain me why its working? — Emmad Zahid, Dec 18 '15 at 05:54
See here you corrected your sql instance name and DB path. you can check following link to know about |DataDirectory|. http://stackoverflow.com/questions/1409358/ado-net-datadirectory-where-is-this-documented — Nirav Kamani, Dec 18 '15 at 08:05

score -1 · Answer 2 · answered Dec 18 '15 at 05:42

-1

check sql server express is install or not on your machine if not then use local sql server that is install on your machine and change connection string data source=.; initial catalog=DEMODB; user id=abc; password=123;

answered Dec 18 '15 at 05:42

Priyank Gangwar

1
1

Database connection not working in ASP MVC

2 Answers2