Not Automatically reconnecting restored tabs

Tianjiao_Li

@ahdung

Unfortunately our issue trackers are all internal. I'll keep here updated as soon as there is any meaningful updates.

ahdung

@Tianjiao_Li I see, thank you.

jondcoleman

I'm having the same issue.

Here's my version:

ahdung

9.5.8 still not fix SP-7650, what do you think man? This issue should be increase to emergency level.

Tigs

I've got this issue too with SSMS 18.1, SQLPrompt 9.5.8.10521

ahdung

do you fixed this?

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.

ahdung

@TomWalshGreat, thank you very much.

TomW

This release should now be available to you all. Please get in touch if there are still any issues.

Thanks,
Tom

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

TomW

Glad to hear it's all working @doowruc

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

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.

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.

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?

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.

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.

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

August 22, 2019 10:59AM

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

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

August 22, 2019 10:59AM

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

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

August 22, 2019 10:59AM

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

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

August 22, 2019 10:59AM

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

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

August 22, 2019 10:59AM

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

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

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

ahdung

@doowruc same with your

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

August 22, 2019 10:59AM

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

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

August 22, 2019 10:59AM

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

@Tianjiao_Li @Russell D Please see my post from August 28, 2019 11:26AM - the fix is not complete. 

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

doowruc

Hi @TomW yes, save password is checked every time.