SSMS v17 - Object must implement IConvertible. (mscorlib)
When a query is selected with the mouse/keyboard, and then "Analyze Query in Database Engine Tuning Advisor" option in the context menu is selected the following error appears.
"The argument type 'server type = Sql, server name = KSHQ-DB, timeout = 30, database = KSH_Cloudcare, protocol = NotSpecified, workstation = , integrated security = True' cannot be converted into parameter type 'Microsoft.SqlServer.Management.Common.SqlConnectionInfo'. (mscorlib)
Object must implement IConvertible. (mscorlib)"
This is a known issue and it is being fixed (probably in the next major release of SSMS).
Aside from the workaround listed here (update the dtashell.exe.config), another “workaround” is to upgrade from a previous version of SSMS 17.x (e.g. going from 17.4 to 17.5): that has the nice side effect of fixing the dtashell.exe.config as well.
Same issue 17.9.1...
Juri Kirillov commented
And still in 17.9
Panayiotis Panayiotou commented
Still facing it with 17.8.1
Still a problem in 17.7 too
Same problem in 17.5
It appears to happen in 17.5. Microsoft SQL Server Management Studio 14.0.17224.0 has the issue.