Crash with linked servers using the current login context

mattbenham

We are experiencing a SQL prompt crash with linked servers that are correctly configured to use Kerberos double-hop to authenticate using the current login context.  When typing a reference to a view, the Redgate object suggestions picker attempts to display a preview of the view script, but it then it immediately crashes.  It does not crash when tables or SPs are selected in the object picker, or when the linked server has a login context manually entered in the configuration.

To replicate, create a linked server between instances where Kerberos double-hop is configured.  Ensure that connections be made using the login's current security context.  Browse to the linked server in SSMS and confirm that under the catalogs, it shows you the list of accessible DBs.  Now type a query:

SELECT * FROM [Linked Server].[DB].[Schema].[ViewName]

You should get a crash at the point that the object picker highlights a view and tries to preview it.

I have also submitted a crash report from the application.  This is with SQL Prompt 10.6.10.19533 and SSMS 18.9.1

ATurner

Hi Matt

Thanks for letting us know! I am going to try to reproduce that one here.

ATurner

Hi Matt, might need some log files from you for this as well! So I'm going to create a ticket to look into this issue for you. I will email you shortly. 

mattbenham

I can confirm that the fix in version 10.6.12.20269 fully resolves the issue.  Thanks for the rapid identification development of a fix.