Tabs are no longer reconnecting when SSMS starts up

• 
  It's difficult to troubleshoot if the issue is intermittent. Few questions would help:
  1- how many tabs were open when this issue occurred and were all tabs not reconnecting?
  2- were the tabs that didn't reconnect from one specific database?
  3- do you have this issue with any other version of SSMS?
  4- if you restore the Prompt options to default (SQL Prompt ->Options->Restore all defaults), restart SSMS, does it help?
  5- do you notice any pattern when this issue occurs?

  Tianjiao_Li July 26, 2019 09:55

  - 0 +
• 

  Tianjiao_Li said:

  It's difficult to troubleshoot if the issue is intermittent. Few questions would help:
  1- how many tabs were open when this issue occurred and were all tabs not reconnecting?
  2- were the tabs that didn't reconnect from one specific database?
  3- do you have this issue with any other version of SSMS?
  4- if you restore the Prompt options to default (SQL Prompt ->Options->Restore all defaults), restart SSMS, does it help?
  5- do you notice any pattern when this issue occurs?

  
  1) This last time, 28 tabs were reopened, but not connected. 3 of those tabs were reconnected. Most of the unconnected tabs were pointing to the same server/database as the reconnected ones.
  
  2) Mostly one since that is what I am currently focused on right now, but as I mentioned in #1, I did get a couple of reconnects to the same server/database.
  
  3) Not that I remember. If I did, it was a long time ago.
  
  4) Oh! That sounds drastic. OK, I did an Export of all of my settings and then clicked Restore all defaults. I connected a couple of tabs as a test, then restarted SSMS. I noticed that most of my tabs now reconnected with the exception of a couple that used a SQL User/Password to connect, even though I have saved the password in SSMS.
  
  5) The only pattern that I noticed is that I have tabs open and connected, I quit SSMS. I restart SSMS, and most of my tabs are not reconnected.
  
  Now I have to try and figure out what all of the settings are that I lost, like all of my custom aliases :-(
  

  JimF July 26, 2019 14:15

  - 0 +
• 

  JimF said:

   I noticed that most of my tabs now reconnected with the exception of a couple that used a SQL User/Password to connect, even though I have saved the password in SSMS.
  

  
  

  This is a known issue which we logged as SP-7650 when using SQL Authentication. We haven't got a ETA for the fix, so please keep an eye on the release note.
  
  So sorry about the lost of your custom aliases. If it's too difficult to redefine your custom aliases, you can take few screenshots of the default settings, then revert to your old setting and manually go through the difference between your settings and the default one.
  
  
  

  Tianjiao_Li July 31, 2019 09:27

  - 0 +
• 
  @Tianjiao_Li Could you tell me what the progress of SP-7650.

  ahdung August 20, 2019 06:23

  - 0 +
• 
  Hi everyone,
  
  Tom from the Prompt team here. We've fixed this issue and we'll be shipping that fix to you all later this week. Sorry for the inconvenience this has caused in the meantime.
  
  Please get in touch if you have any other issues.
  
  Thanks.
  

  TomW August 20, 2019 08:17

  - 0 +
• 
  This release should now be available to you all. Please get in touch if there are still any issues.
  
  Thanks,
  Tom
  

  TomW August 22, 2019 14:40

  - 0 +
• 
  I have a continuing issue with tabs opening but not reconnecting when I start up SSMS.
  
  I have "Automatically reconnect restored tabs" checked.
  All tabs are connected via Windows Authentication.
  
  When I last restarted SSMS I had 27 tabs open only 7 of which reconnected.
  Connections would all have been to the same database.
  
  I have also noticed that some of the tabs have the same name.
  Some of these are connected whilst others are not.
  Each window has different content.
  
  
  SSMS: -
  
  
  SQL Prompt: -
  
  
  
  
  

  Redshift June 06, 2023 13:59

  - 0 +

Add comment

Please sign in to leave a comment.