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

Question

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

Tony S 6

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?

David Browne - msft 3,761 Reputation points

2020-12-31T15:47:48.043+00:00

How are you running as another user? runas? runas /netonly? Has the other user ever logged to the local machine?
Tony S 6 Reputation points

2020-12-31T15:50:54.523+00:00

Right Click - Run As a different user.

The user account has logged in to the device before. I actually cleared the quick access cache for File Explorer on that user thinking that would cause an issue - no change in behavior. Running SSMS in that user's session does not reproduce the issue, but unfortunately that is not a viable solution.
David Browne - msft 3,761 Reputation points

2020-12-31T16:50:07.483+00:00

Then try with runas /netonly. This will not log the other user on, but will use the provided credentials for connecting to SQL Server. eg

runas /user:OtherUser /netonly "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"
Tore Olafsson 1 Reputation point

2021-03-03T14:52:12.99+00:00

I had the same issue and it turned out to be a simple Windows permissions thing. In other words if you give the user you are opening SSMS as permissions to the file/folder you are trying to open then it should be all good, hope that helps.

David Browne - msft 3,761 Reputation points

2020-12-31T15:47:48.043+00:00

How are you running as another user? runas? runas /netonly? Has the other user ever logged to the local machine?
Tony S 6 Reputation points

2020-12-31T15:50:54.523+00:00

Right Click - Run As a different user.

The user account has logged in to the device before. I actually cleared the quick access cache for File Explorer on that user thinking that would cause an issue - no change in behavior. Running SSMS in that user's session does not reproduce the issue, but unfortunately that is not a viable solution.
David Browne - msft 3,761 Reputation points

2020-12-31T16:50:07.483+00:00

Then try with runas /netonly. This will not log the other user on, but will use the provided credentials for connecting to SQL Server. eg

runas /user:OtherUser /netonly "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"
Tore Olafsson 1 Reputation point

2021-03-03T14:52:12.99+00:00

I had the same issue and it turned out to be a simple Windows permissions thing. In other words if you give the user you are opening SSMS as permissions to the file/folder you are trying to open then it should be all good, hope that helps.

Answer 1

CathyJi-MSFT 20,986 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,
Cathy

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.

Tony S 6 Reputation points

2020-12-31T15:12:02.717+00:00

Hi Cathy, thank you for the reply. The run as administrator will not work in this case as we have multiple usernames with different permission levels and this account is not actually an admin account. The problem did persist in SSMS 17 before being upgraded to SSMS 18, thinking that would "fix" the issue. The computer has been restarted as well.

As for the old similar solution, it doesn't appear to be the same as the dialog box works fine until clicking into the "Search" folder box in the upper right corner. In fact, the user doesn't even have any mapped network folders within that account that would be slowing it down.

Thanks again!
David Reavill 1 Reputation point

2021-01-19T15:14:36.747+00:00

I am experiencing the same crashes if I use the file search field in the file open dialogs of both the latest versions of SSMS 17 and SSMS 18. Are these dialogs extended versions of the standard OS file open dialogs?

I too thought upgrading to SSMS 18 would resolve the issue, but it did not.

By the way, it has nothing to do with logging on as another user. I am an admin on my machine and run SSMS with normal startup.

Answer 2

Tore Olafsson 1

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.

Answer 3

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!

C

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

3 answers

Activity