Geek Answers Handbook

SQL Studio 2008 Management Studio Open Dialog Box Does Not Answer

I am having problems opening files in SQL Server Management Studio.

I can connect to the local database normally (SQL Server std. 2008 R2), but when I do File> Open> Open File, the dialog just hangs until it says "Do not respond".

It eventually connects, but freezes for 20-30 seconds to move between each folder on the local network.

I do not have the same problem as in the same folders using Windows Explorer or Visual Studio 2012. It seems that this only happens with SQL Server Management Studio.

I tried to find the thread to find the resolution, but the only thread I found removed the solution link!

+4
source share
6 answers

If you have a network share, delete it and try.

Did the file open dialog get stuck on one of the mapped drives?

Also check https://dba.stackexchange.com/questions/20725/sql-server-management-studio-slow-opening-new-windows

Hope this helps. PS: Have you installed the latest SP?

+5
source

I am running Windows 7 and SSMS 2008, and I also had this very nasty problem, but only with SSMS. I tried to open each of the mapped drives, and I disconnected all that had the wrong paths. More problems!

+1
source

I had this problem and I have network resources. I upgraded SQL Server 2008 R2 to Service Pack 2. Now the problem has disappeared. I did not have to touch my network resources.

0
source

I had the same problem, every time I click on the open file dialog for sql file, ssms just freezes and takes 30-40 seconds to respond. I uninstalled 32-bit SQL Server 2005 32-bit 64-bit Windows 7 and installed 64-bit SQL Server, but the problem was not resolved. I found that the network drive was disconnected, I removed the unmapped drive and the problem was resolved without delay. I am surprised how strange it is that an unmapped drive can cause performance problems with SQL server tools.

0
source

I have a very simple solution:

  • Close SSMS using the task manager.
  • Reopen SSMS.
  • Decision:
    • The tray creates a script from any database (only the tray until the Open File dialog box appears).
    • Close the Open File dialog box.
    • The problem is resolved.
    • Now you can use the "Open File Dialog"
0
source

I had the same issue with SQL Server 2014sp1 that does not display the File Browser dialog box. Unmounting the SQL Server installation media in Hyper-V Manager for VM resolved the issue.

0
source

More articles:


All Articles