Cannot open user default database. Login failed. Login faile

发布时间：2020-12-12 15:34:43 所属栏目：MsSql教程来源：网络整理

导读：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

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.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!