用户登录失败＆QUOT; XXX＆QUOT;无法打开明确指定的数据库解决方案 [英] Login failed for user "xxx" Failed to open the explicitly specified database solution

问题描述

林先使用实体​​框架code。当启动应用程序的应用程序试图创建SQLServer2008R2数据库。

Im using entity framework code first. When starting the application the application tries to create the database on SQLServer2008R2.

这是我收到的错误信息是：

The error message that I'm receiving is:

用户登录失败NT instans \网络服务无法打开明确指定的数据库

在更仔细地看问题，在SQLServer的日志，我可以看到错误code为：18456严重性14状态38。 阅读它：的http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/

After looking more carefully at the problem in the SQLServer log i can see that the error code is: 18456 severity 14 with state 38. Read about it on: http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/

不要任何人有一个想法如何解决这个问题？

Do anybody have a idea how to solve this problem?

推荐答案

我想我要放一个解决方案，在这里，我两个程序员之间浪费太多时间后发现：删除名为.suo 文件。我知道最初的问题被问18个月前​​，但它可能挽救一个人过这个问题，未来的未来。

I just thought I'd put a solution here that I found after wasting between two programmers too much time: delete the .suo file. I realise the initial question was asked 18 months ago but it might save someone coming across this question in the future.

我们尝试安装不同版本的Visual Studio，删除的LocalDB实例，登录为SA，应有尽有。

We tried installing different versions of Visual Studio, deleting localdb instances, logging in as SA, everything.

这篇关于用户登录失败＆QUOT; XXX＆QUOT;无法打开明确指定的数据库解决方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！