“添加连接”对话框不显示 Visual Studio 中的所有数据库
这是使用“服务器资源管理器”[单击带有绿色加号图标的鼓]进行连接以建立数据源连接时的情况。发生的情况是它确实显示了系统数据库，但不显示我们从另一个系统导入的数据库。这些数据库位于 SQL Management Studio 中的单独目录中。
早些时候，当我连接到同一数据库时，我收到一条错误消息，指出该数据库没有所有者。我不再收到该消息了。但这些数据库仍然没有填充在下拉框中。
其次，我无法从最初开发它们的项目连接到数据库。我们确实更改了一些内容，这意味着我们将数据库从生产版本迁移到开发人员环境中。有人知道如何解决这个问题吗？
更新：解决方案
让我自己回答...
并非所有数据库都显示，因为计算机上运行着三个数据库引擎。用户数据库导入到错误的服务器而不是 EXPRESS 服务器中，因此数据库未在 Express 服务器中显示。
对于连接错误，显然如果没有数据库，则无法建立连接。不过，我现在收到了更多关于连接的有针对性的错误。
谢谢贾斯汀。
谢谢你！
This is when connecting to establish a datasource connection using "Server Explorer" [clicking the drum with a green plus icon]. What happens is it does show the system databases but not the databases that we imported from another system. These databases are in separate directory in SQL Management Studio.
Earlier when I connecting to the same database, I was getting an error msg that the database does not have owner. I dont get that msg anymore. But these databases are still not populated in drop down box.
Second I have trouble connecting to the database from the project where they were originally developed in. We did change something that means we migrated databases from the production version into the developer environment. Does anybody know how to fix that as well?
update: Solution
Let me answer it myself...
Not all databases were showing because there were three databases engine running on the machine. The user databases were imported into the wrong server not the EXPRESS one, hence the database were not showing in express server.
As for connectivity errors, obviously if there is no database, no connection can be established. I am getting more targeted errors now regarding the connection though.
Thanks Justin.
Thank you!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
听起来您对数据库的所有权有疑问。我将登录 Sql Server Manager，然后检查数据库的安全设置 - 您登录的用户是否有 dbo？
It sounds like you're having an issue with ownership of the database. I would log into Sql Server Manager, and check the security settings on your databases - does the user you are logging in with have dbo?
让我自己回答...
并非所有数据库都显示，因为机器上运行着三个数据库引擎。用户数据库被导入到错误的服务器，而不是我正在使用的 EXPRESS 服务器。
对于连接错误，显然如果没有数据库，则无法建立连接。不过，我现在收到了更多关于连接的有针对性的错误。
Let me answer it myself...
Not all databases were showing because there were three databases engine running on the machine. The user databases were imported into the wrong server not the EXPRESS one that I was using.
As for connectivity errors, obviously if there is no database, no connection can be established. I am getting more targeted errors now regarding the connection though.