I have a fresh installation of Windows 10, on which Microsoft Visual Studio 2015 was installed (therefore, a default database was installed too). I installed SQL Server Management Studio 2016 (v13.0.16106.4) but could not connect with the following error message:
Cannot connect to MYSERVER\SQLEXPRESS.
Method not found: 'Void Microsoft.SqlServer.Management.Common.SqlConnectionInfo.set_IsActiveDirectoryUniversalAuth(Boolean)'. (ConnectionDlg)
I've since tried to:
- Install SQL Server 2016
- Uninstall both SQL Server 2016 and the one coming with Visual Studio 2015 (following http://intellitect.com/sql-server-2008-install-nightmare/)
- Once everything was cleaned and after a reboot, install SQL Server 2016 with default settings
- Repair Microsoft SQL Server Management Studio
Note that regardless of what I try to connect to (including typing junk in the server text box), I have the same message, which leads me to believe that the error happens before SSMS actually tries to connect to the server.
I'm out of ideas; it seems like a DLL file may be missing, but which one and why, I cannot say.
The only "useful" reference I have found is this technet forum post which refers to a "patch", but I can't find where this "patch" could be found, if it exists.
I can connect with
sqlcmd -S mymachine\SQLEXPRESS; I can also run queries like
SELECT * from sys.databases successfully.