How can we help you today? How can we help you today?

Not Automatically reconnecting restored tabs

Hi, I am using SQL Prompt 7.2.4.291. Recently, I noticed that my tabs are not reconnecting when I reopen SSMS. Tabs connnected using SQL Server Auth seem to be working ok, but the tab where I was connected using Windows Auth are not reconnecting to the server they were connected to when I closed SSMS. I have validated that the "Automatically reconnect restored tabs" checkbox is checked, but it's not working. This used to work for me, but hasn't been working recently. Is there something else I need to do?

Thanks,
Jana
JustJay
0

Comments

74 comments

  • Tianjiao_Li
    @ahdung

    Unfortunately our issue trackers are all internal. I'll keep here updated as soon as there is any meaningful updates.
    Tianjiao_Li
    0
  • ahdung
    @Tianjiao_Li I see, thank you.
    ahdung
    0
  • jondcoleman
    I'm having the same issue.

    Here's my version:


    jondcoleman
    0
  • ahdung
    9.5.8 still not fix SP-7650, what do you think man? This issue should be increase to emergency level.
    ahdung
    0
  • Tigs
    I've got this issue too with SSMS 18.1, SQLPrompt 9.5.8.10521
    Tigs
    0
  • ahdung
    do you fixed this?
    ahdung
    0
  • TomW
    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
    0
  • ahdung
    @TomWalshGreat, thank you very much.
    ahdung
    0
  • TomW
    This release should now be available to you all. Please get in touch if there are still any issues.

    Thanks,
    Tom
    TomW
    0
  • doowruc
    Installed - can confirm it is once again working - it even restored connection on my open tabs from when I closed to install the update

    Many thanks
    doowruc
    0
  • TomW
    Glad to hear it's all working @doowruc :)
    TomW
    0
  • Tianjiao_Li
    Hi

    Thanks for your patience with this issue!

    I'm pleased to let you know the fix has been released. Please upgrade or here is the direct download - http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.14.11144.exe
    Tianjiao_Li
    0
  • dfalzone
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    dfalzone
    0
  • Russell D
    dfalzone said:
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    That’s because apex sql actively hijack the way we hook into ssms, so there’s nothing we can do about that. You’d need to ask them to stop doing that.
    Russell D
    0
  • doowruc
    dfalzone said:
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    Purely out of interest, why do you have both? Does SQL Prompt not do everything that Refactor does?
    doowruc
    0
  • dfalzone
    doowruc said:
    dfalzone said:
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    Purely out of interest, why do you have both? Does SQL Prompt not do everything that Refactor does?

    Redgate came second.
    dfalzone
    0
  • ahdung
    9.5.14.11144 still have problem.
    my ssms never exit, and pc will hibernate every night, some morning, the tabs use sql auth way will not reconnect, but the tabs use SSPI didn't.
    since upgrade to 9.5.14.11144, this issue occured few times, please help.
    and i'm not have any apexsql thing.
    ahdung
    0
  • dfalzone
    Russell D said:
    dfalzone said:
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    That’s because apex sql actively hijack the way we hook into ssms, so there’s nothing we can do about that. You’d need to ask them to stop doing that.
    Russel this thread is about redgate not reconnecting tabs when starting ssms with apex. As you see Tianjiao posted the thread below on 8/22 stating the issue was resolved via  9 5 14 11144.exe. I letting you know it didnt fix the issue as stated. If youd like apex to stop doing something please feel free to reach out on your own. I'd prefer to not be in the middle of your beef with apex.

    Tianjiao_Li Redgate › Posts: 447 Rose Gold 2
    Hi

    Thanks for your patience with this issue!

    I'm pleased to let you know the fix has been released. Please upgrade or here is the direct download - http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.14.11144.exe
    dfalzone
    0
  • dfalzone
    Russell D said:
    dfalzone said:
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    That’s because apex sql actively hijack the way we hook into ssms, so there’s nothing we can do about that. You’d need to ask them to stop doing that.
    Russel this thread is about redgate not reconnecting tabs when starting ssms with apex. As you see Tianjiao posted the thread below on 8/22 stating the issue was resolved via  9 5 14 11144.exe. I letting you know it didnt fix the issue as stated. If youd like apex to stop doing something please feel free to reach out on your own. I'd prefer to not be in the middle of your beef with apex.

    Tianjiao_Li Redgate › Posts: 447 Rose Gold 2
    Hi

    Thanks for your patience with this issue!

    I'm pleased to let you know the fix has been released. Please upgrade or here is the direct download - http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.14.11144.exe
    dfalzone
    0
  • dfalzone
    Russell D said:
    dfalzone said:
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    That’s because apex sql actively hijack the way we hook into ssms, so there’s nothing we can do about that. You’d need to ask them to stop doing that.
    Russel this thread is about redgate not reconnecting tabs when starting ssms with apex. As you see Tianjiao posted the thread below on 8/22 stating the issue was resolved via  9 5 14 11144.exe. I letting you know it didnt fix the issue as stated. If youd like apex to stop doing something please feel free to reach out on your own. I'd prefer to not be in the middle of your beef with apex.

    Tianjiao_Li Redgate › Posts: 447 Rose Gold 2
    Hi

    Thanks for your patience with this issue!

    I'm pleased to let you know the fix has been released. Please upgrade or here is the direct download - http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.14.11144.exe
    dfalzone
    0
  • dfalzone
    Russell D said:
    dfalzone said:
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    That’s because apex sql actively hijack the way we hook into ssms, so there’s nothing we can do about that. You’d need to ask them to stop doing that.
    Russel this thread is about redgate not reconnecting tabs when starting ssms with apex. As you see Tianjiao posted the thread below on 8/22 stating the issue was resolved via  9 5 14 11144.exe. I letting you know it didnt fix the issue as stated. If youd like apex to stop doing something please feel free to reach out on your own. I'd prefer to not be in the middle of your beef with apex.

    Tianjiao_Li Redgate › Posts: 447 Rose Gold 2
    Hi

    Thanks for your patience with this issue!

    I'm pleased to let you know the fix has been released. Please upgrade or here is the direct download - http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.14.11144.exe
    dfalzone
    0
  • doowruc
    dfalzone said:
    Russell D said:
    dfalzone said:
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    That’s because apex sql actively hijack the way we hook into ssms, so there’s nothing we can do about that. You’d need to ask them to stop doing that.
    Russel this thread is about redgate not reconnecting tabs when starting ssms with apex. As you see Tianjiao posted the thread below on 8/22 stating the issue was resolved via  9 5 14 11144.exe. I letting you know it didnt fix the issue as stated. If youd like apex to stop doing something please feel free to reach out on your own. I'd prefer to not be in the middle of your beef with apex.

    Tianjiao_Li Redgate › Posts: 447 Rose Gold 2
    Hi

    Thanks for your patience with this issue!

    I'm pleased to let you know the fix has been released. Please upgrade or here is the direct download - http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.14.11144.exe
    Actually, the OP has nothing to do with Apex - the original issue happens without Apex being installed
    doowruc
    0
  • doowruc
    So, having now rebooted my PC for the first time since installing the update, the problem is back - none of my tabs have reconnected
    doowruc
    0
  • doowruc
    doowruc said:
    So, having now rebooted my PC for the first time since installing the update, the problem is back - none of my tabs have reconnected
    It appears to be caused by multiple closing and opening of SSMS, not rebooting:

    Steps to reproduce:
    1. open empty SSMS environment
    2. new query
    3. connect
    4. execute
    5. close SSMS
    6. launch SSMS
    7. SSMS opens with previous tab connected
    8. close SSMS
    9. launch SSMS
    10. SSMS opens with previous tab disconnected
    I've tried this repeatedly, reconnecting when it opens disconnected, and it always opens disconnected every 2nd launch.

    Each time I am waiting for SSMS to completely exit and disappear from Task Manager list.

    SSMS v18.1 15.0.18131.0
    SQL Prompt v9.5.14.11144

    I have no other extensions installed
    doowruc
    0
  • ahdung
    @doowruc same with your
    ahdung
    0
  • doowruc
    dfalzone said:
    Russell D said:
    dfalzone said:
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    That’s because apex sql actively hijack the way we hook into ssms, so there’s nothing we can do about that. You’d need to ask them to stop doing that.
    Russel this thread is about redgate not reconnecting tabs when starting ssms with apex. As you see Tianjiao posted the thread below on 8/22 stating the issue was resolved via  9 5 14 11144.exe. I letting you know it didnt fix the issue as stated. If youd like apex to stop doing something please feel free to reach out on your own. I'd prefer to not be in the middle of your beef with apex.

    Tianjiao_Li Redgate › Posts: 447 Rose Gold 2
    Hi

    Thanks for your patience with this issue!

    I'm pleased to let you know the fix has been released. Please upgrade or here is the direct download - http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.14.11144.exe
    Actually, the OP has nothing to do with Apex - the original issue happened without Apex being installed
    doowruc
    0
  • doowruc
    dfalzone said:
    Russell D said:
    dfalzone said:
    Even with the update 9 5 14 11144 ssms 18.2 with latest apexsql refactor loaded doesnt reconnect a single tab with select 1. As soon as i uninstall apex it works.
    That’s because apex sql actively hijack the way we hook into ssms, so there’s nothing we can do about that. You’d need to ask them to stop doing that.
    Russel this thread is about redgate not reconnecting tabs when starting ssms with apex. As you see Tianjiao posted the thread below on 8/22 stating the issue was resolved via  9 5 14 11144.exe. I letting you know it didnt fix the issue as stated. If youd like apex to stop doing something please feel free to reach out on your own. I'd prefer to not be in the middle of your beef with apex.

    Tianjiao_Li Redgate › Posts: 447 Rose Gold 2
    Hi

    Thanks for your patience with this issue!

    I'm pleased to let you know the fix has been released. Please upgrade or here is the direct download - http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.14.11144.exe
    Actually, the OP has nothing to do with Apex - the original issue happened without Apex being installed
    doowruc
    0
  • doowruc
    @Tianjiao_Li @Russell D Please see my post from August 28, 2019 11:26AM - the fix is not complete. 
    doowruc
    0
  • TomW
    Hi @doowruc

    Thanks for sending over your reproduction steps. Could you please confirm whether you've checked the "Remember my password" box on the SSMS connection dialog, as Tab History can't reconnect tabs if that isn't checked?

    Thanks,

    Tom
    TomW
    0
  • doowruc
    Hi @TomW yes, save password is checked every time.
    doowruc
    0

Add comment

Please sign in to leave a comment.