Setup And Getting Started Forum


Error with DB

 
Have just install the DB and am trying to connect but I get this error

The underlying provider failed on Open.

I am using these connection strings
<add name="ApplicationServices" connectionString="Data Source=.\sqlexpress;Initial Catalog=MvcCms;Persist Security Info=True;Integrated Security=true;" providerName="System.Data.SqlClient" />
<add name="MvcCmsEntities" connectionString="metadata=res://MvcCms.Data/MvcCmsDataModel.csdl|res://MvcCms.Data/MvcCmsDataModel.ssdl|res://MvcCms.Data/MvcCmsDataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\sqlexpress;Initial Catalog=MvcCms;Pooling=false;Persist Security Info=True;Integrated Security=true;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

and SQL server 2005
Any ideas?
1 years 3 months 26 days ago by Sunnyland

Replies

Reply posted by jon 1 years 3 months 25 days ago View Branch And Reply
Maybe check that sqlexpress is running and that the MvcCms database is active in it? Most of the time I don't use express so I am not that familiar troubleshooting connection problems with it.

But that would be my first guess.