SSMS 18.8 Crashing with the File->Open->File.. dialog

Tony S 6 Reputation points

As the title says, SSMS 18.8 is crashing when trying to open a file. It specifically happens when running as a different user and clicking in the "search" box in the upper right of the dialog box. I have cleared file explorer quick access on the account the user is running as. It works fine when logging in as that account just fine. I verified search indexing is all good as well.

To give a bit of background, it was working before the user was upgraded to 1909. I believe they were on SSMS 17 and this issue began and then were subsequently upgraded to SSMS 18.8. The issue persists, even after repairing installation.

Any thoughts?

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
8,895 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,003 questions
{count} vote

3 answers

Sort by: Most helpful
  1. CathyJi-MSFT 20,986 Reputation points Microsoft Vendor

    Hi @Tony S ,

    I test this in my environment, it works well. I also using SSMS 18.8. Did you try to run the SSMS 18.8 as administrator as below screenshot? Did you try to restart the computer if possible?


    SSMS 18.8 is supported be installed on Windows 10 (64-bit) version 1607 (10.0.14393) or later. Does SSMS 17.9.1 also have same issue in your environment?

    Please also check if this old similar could help you.

    Best regards,

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Tore Olafsson 1 Reputation point

    I had a similar problem and it turned out to be a simple Windows permission issue. So when I granted the user running SSMS access to the folder where the files were located, it worked fine, hope that helps.

    0 comments No comments

  3. Carl S 21 Reputation points

    I have the same issue with crashing, only using Run As. Setting the file permissions to Full for the user did not help. However, it seems that /netonly is working for me for my use case, which is to pick the user to connect to the database as. SSMS still shows the login user name in the connection box, but the connection is actually made with the Run As user. This can be verified by running SELECT SUSER_SNAME().

    Thanks for the tip!


    0 comments No comments