SSMS 2012 Database Connection Dialog Hangs

• joel.munn

  Old Hand

  Points: 369

  More actions

  February 13, 2015 at 3:48 pm

  #294687

  I have several users with an unusual problem with SSMS 2012. When they attempt to connect to a database using the "Connect to Server" dialog box, the connection just hangs. Sometimes after about 15 minutes the connection will be successful. Other attempts simply spin seemingly endlessly. Users experiencing this issue are both running SSMS 2012 on Win 7 Pro (64 bit). The following troubleshooting steps have been tried:

  1. When the user runs SSMS "As Administrator" the connections work almost instantly. (Elevating privileges is not a solution in our environment)

  2. Wireshark shows that SSMS does not try to hit the SQL server when the user experiencing this issue clicks connect.

  3. I can create a new virgin user on the PC and that login experiences the same problem.

  4. A complete rip and re-install of SSMS 2012 does not resolve the issue.

  Do you have any thoughts or suggestions?

  JM

• cathrinegarcia24

  SSC Enthusiast

  Points: 163

  More actions

  February 16, 2015 at 6:10 am

  #1777805

  Hie joel

  According to me clearing all your MRU history is the best solution as I have tried it, it worked for me.

  1. All you have to do is go on SSMS 2012 and close all instance already opened.

  2. Go to Explorer, open "data_name\Microsoft\SQL Server Management Studio"

  3. Rename the folder to something else.

  4. Now go on SSMS 2012 and open it.

  So by doing this you will see that all your MRU history is cleared just enter your username and password and use SSMS. I hope this will work.Feel free to ask.

  Regards

• joel.munn

  Old Hand

  Points: 369

  More actions

  February 17, 2015 at 8:30 am

  #1778079

  We tried his fix and it does solve the problem for a single attachment for only one of my users and then SMSS reverts to this same puzzling behavior.

  Are there any more thoughts about this issue out there?

  JM

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  February 17, 2015 at 8:47 am

  #1778085

  I don't have any idea why this is happening, but I would personally fire up Process Monitor

  from https://live.sysinternals.com/tools

  Filter it down to SSMS and see what is happening.

  The other troubleshooting you could try (which will be easier than Procmon) is to enable the SSMS log by launching it with the /log switch.

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]