VS 2010与SQL 2008 R2的新连接问题
系统信息:
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?