VS 2010与SQL 2008 R2的新连接问题 [英] VS 2010 new connection to SQL 2008 r2 problem

问题描述

系统信息:
Windows 7(64)，全新安装VS和SQL2008 r2.
VS2010 Ultimate SP1
可通过下载SQLEXPRWT_x64来安装SQLExpress.
没有任何Windows更新显示
在SQL配置管理器中同时具有SQL和SQLExpress实例
SQL配置登录为:两者
启用了TCP
SQL Browser服务正在运行

症状:
因此，在VS中的新建连接"对话框中看不到我在SQL Management Studio中添加的新内容.

仅对于Windows身份验证登录，连接测试成功.这意味着如果我在Management Studio中添加新的SQL用户，则连接测试将因为登录而失败.

即使使用Windows身份验证登录，也仅可见系统数据库".我在Management Studio中创建或还原的任何数据库对于数据库名称"字段中的VS新连接"对话框都不可见.

哦，对不起，没有提出问题.整日用Google搜索，但找不到一个报告此特定问题的人，只有一个没有在其他论坛上获得解决方案的人.

这是我去寻求帮助的地方，任何人都有如何尝试解决此问题的想法吗?

System Info:
Windows 7(64), fresh install of both VS and SQL2008 r2.
VS2010 Ultimate SP1
SQLExpress is installed from download of SQLEXPRWT_x64
Have no Windows Updates showing for either
Have both instances of SQL and SQLExpress in SQL Config Manager
SQL config login is: both
have TCP enabled
SQL Browser Service is running

Symptoms:
So nothing I add new in SQL Management studio is visible from VS in the "new connection" dialog.

Connection Test succeeds for my Windows auth log on only. Meaning if I add a new SQL user in Management Studio, Connection Test fails for it as the log on.

Even using Windows auth log on, only "System Databases" are visible. Any database I create or restore in Management Studio is not visible to the VS "new connection" dialog in the "database name" field.

Oh, sorry, didn''t ask a question. Googled all day but not found anyone reporting this specific problem other than one person that did not get a solution on that other forum.

This is my go to place for help, anyone have any ideas how to try and resolve this?

推荐答案

您可能需要

这篇关于VS 2010与SQL 2008 R2的新连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！