Cannot open user default database. Login failed. Login failed for user 'Machine/ASPNET'

最新推荐文章于 2018-05-30 15:56:16 发布

最新推荐文章于 2018-05-30 15:56:16 发布 · 219 阅读

文章标签：

#数据库

本文解决了ASP.NET应用程序中遇到的一个常见问题：当尝试从浏览器运行应用程序时出现“无法打开默认数据库”的错误。作者发现问题是由于数据库连接在IDE中未被正确关闭导致，并给出了具体的解决步骤。

question:

Having the same problem and have spent 2 frustrating days trying to figure it out. Project runs from within VS.net OK -- because VS is authenticating as [machine]/ASPNET -- but if I try to run as http://localhost/[application] I just get the "Cannot open user default database..." error. I've created a [machine]/ASPNET user account in SQL Server Express, assigned it to sysadmin role, have set SQL Express to run in mixed-mode, but all to no avail.

the way to fix:

I had the same use and tried a whole bunch of things, but this is what solved it for me:

- it seems I had the DB still opened inside my IDE (Visual Web Developer Express), in the database explorer. Right-clicking the database and selecting "close connection" fixed it.

Hope this helps.