CODEWITHSUNDEEP
sql-serversql-server-2008windows-7-x64
Andrew Kelly
Andrew Kelly

Reputation: 123

SQL Server 2008 Management Studio open file dialog not responding

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

I can connect fine to the local database (SQL Server std. 2008 R2), but when I do File > Open > Open File, the dialog just hangs until it says 'Not Responding'.

It does eventually connect, but hangs for a period of 20-30 seconds to navigate between each folder on the local network.

I do not have the same problem navigating the same folders with windows explorer or Visual Studio 2012. It seems that this only occurs with SQL Server Management Studio.

I have tried to find a thread to find a resolution, but the only thread I did find had the link removed to the solution!

Upvotes: 4

Views: 5364

Answers (6)

jessehouwing
jessehouwing

Reputation: 115037

I had the same issue with SQL Server 2014sp1 not showing the File Browser dialog. Unmounting the SQL Server installation media in the Hyper-V manager for the VM solved the issue.

Upvotes: 0

Percy Rojas
Percy Rojas

Reputation: 1

I have an solution very easy:

  1. Close the SSMS with the Task Manager.
  2. Open again SSMS.
  3. Solution:
    • Tray generate an script from any Database (only tray, until appear the Open File Dialog).
    • Close the Open File Dialog.
    • The problem is solved.
    • Now you can use the "Open File Dialog"

Upvotes: 0

user2026039
user2026039

Reputation: 51

I had the same issue, every time i click open file dialog for sql file, ssms just hangs and takes 30-40 seconds to respond. I uninstalled SQL Server 2005 32 bit on 64 bit windows 7 and installed 64 bit of SQL Server but the problem did not resolve.. I found there was a network drive unmapped, I deleted unmapped drive and problem resolved with no delays. I am surprised how weird it is that unmapped drive can cause problem in sql server tools performance.

Upvotes: 0

Mark Bailey
Mark Bailey

Reputation: 1131

I was having this problem, and I do have network shares. I upgraded SQL Server 2008 R2 to service pack 2. Now the problem is gone. I didn't have to touch my network shares.

Upvotes: 0

Elizabeth Fisher
Elizabeth Fisher

Reputation: 11

I'm running Windows 7 and SSMS 2008 and was also having this very frustrating problem, but only with SSMS. I tried opening each of my mapped drives, and I disconnected any that had invalid paths. No more problem!

Upvotes: 1

Milind Thakkar
Milind Thakkar

Reputation: 980

If you have any network share, remove it and try.

Probably, Open file dialog is stuck at one of the mapped drive?

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

Hope that helps. PS: Have you installed latest SP?

Upvotes: 5

Related Questions