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
[Save my password] must be checked
回覆刪除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