2017年3月10日 星期五

[研究] [Bug ?] Success from Visual Studio 2017 IDE connecting SQL Server, but "Tables" can not be displayed (1)

[研究] [Bug ?] Success from Visual Studio 2017 IDE connecting SQL Server, but "Tables" can not be displayed (1)

2017-03-10

It is is normal on Visual Studio 2015 with Update 3.
When I upgraded to VS 2017,  the problem. happend.
VS2017 Bug ???







Failed to retrieve data for this request.
Failed to connect to server (local).
User 'sa' login failed.

I can see Tables on Visual Studio 2015 in the past, but can not see on Visual Studio 2017 now.
I still can see Views  on Visual Studio 2017 now.

I confirm that I had install SQL Server Data Tools (SSDT)


I test on several PC, but all  failed

  • Windows Server 2016 + SQL Server 2016 + Visual Studio 2015 with Update 3, install Visual Studio 2017 (two sets of Visual Studio coexistence)
  • Windows Server 2016 + SQL Server 2016 + Visual Studio 2015 with Update 3, first install Visual Studio 2017, remove Visual Studio 2015 with Update 3
  • Windows 7 x64 + SQL Server 2014 + Visual Studio 2015 with Update 3, remove Visual Studio 2015 with Update 3, remove Visual Studio 2015 with Update 3

Bug?

********************************************************************************

If  I use "Windows Authentication"  on Visual Studio 2017, I can see Tables.


********************************************************************************

( To be continued ... )


Relation :

[研究] Bug ? Visual Studio 2017 IDE connect SQL Server 2016 4th Test
http://shaurong.blogspot.com/2017/03/bug-visual-studio-2017-ide-connect-sql.html

[Bug ?] Success from Visual Studio 2017 IDE connecting SQL Server, but fail to show "Tables"
http://shaurong.blogspot.com/2017/03/bug-success-from-visual-studio-2017-ide.html

[研究] [Bug?] 從 Visual Studio 2017 IDE 連線資料庫成功,但 "資料表" 無法顯示
http://shaurong.blogspot.com/2017/03/bug-visual-studio-2017-ide.html


2 則留言:

  1. [Save my password] must be checked

    回覆刪除
    回覆
    1. Yes, please see below :

      [研究] [Bug ?] Success from Visual Studio 2017 IDE connecting SQL Server, but "Tables" can not be displayed (2) 4th Test
      http://shaurong.blogspot.tw/2017/03/bug-visual-studio-2017-ide-connect-sql.html

      刪除