Asp.net MVC: the underlying provider failed to open. error

Help me where I am wrong

Here with I attach my mvc code.

#view

#controller

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MVCDemo2.Models;
namespace MVCDemo2.Controllers
{
public class EmployeeController : Controller
{
public ActionResult Details(int id)
{
EmployeeContext employeeContext = new EmployeeContext();
Employee employee = employeeContext.Employees.Single(emp => emp.EmployeeId == id);
return View(employee);
}
}
}

#EmployeeContext

#webConfig

<connectionStrings>
<add name="EmployeeContext" connectionString="Data Source=ADMIN-PC3\SQLEXPRESS;Initial Catalog=employee;Integrated Security=true"
providerName="System.Data.SqlClient"/>
connectionStrings>

but Run time Error "EntityException was unhandled by user code" The Underlying provider failed on on Open.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

mevada kamlesh8y ago
not solve issue remove integrated security="true" then same issue found my coonection string ok and server working fine
0
Manav Pandya8y ago
Hello

I thought problem with security option , just remove below from your connection string :
Integrated Secirity="true"
Because you have no provided your username or password , thats why no need to use those portion in connection string
OR

Make sure your connection string is ok and server is started and available

I hope it will be helpful to solve you issue

Thanks
0
mevada kamlesh8y ago
sql server database already connected through wondow authentication
+1
devangana8y ago
Try connecting to the sql server database through windows authentication
0