Tabs don't remember connections when using Azure Managed Instance

jamesbuckley

Feels like a bug.
It can be replicated using the following steps.

Open SSMS
Connect to Non Azure Managed Instance Server
Create New Query ( 1 )
Connect to Managed Instance Server
Create New Query ( 2 )
Close SSMS
Reopen SSMS

Result
New Query ( 2 ) does not remember what database it was connected to but New Query ( 1 ) does.

Any Solution?

Dan_J

Hi @jamesbuckley

Thanks for reaching out about this!

I'm going to be testing this, but before I do so, would you mind confirming what versions of SQL Prompt and SSMS you currently have installed?

jamesbuckley

Hi @Dan_J,

It happens on all variations as far as I'm aware.

My SSMS:

SQL Server Management Studio 19.0.20209.0+f9a9d8f6

SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973

Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e

Microsoft Analysis Services Client Tools 16.0.19993.0

Microsoft Data Access Components (MDAC) 10.0.19041.3208

Microsoft MSXML 3.0 6.0 

Microsoft .NET Framework 4.0.30319.42000

Operating System 10.0.19045

And SQL Prompt is 10.13.14.2694.

Cheers,
James

Dan_J

Hi @jamesbuckley

Thanks for your reply on this.

I think I have a reproduction of this issue here and have engaged our development team for their input.

I will come back to you on this as soon as I have an update for you.

Dan_J

Hi @jamesbuckley

Following my last message, I'm pleased to advise that a fix for this issue is due to be included in the next release of SQL Prompt. 

I'm not sure yet if that will be next week, or in a few weeks time, but I will let you know as soon as I know more.

Thanks for your patience with us on this.

jamesbuckley

thanks @Dan_J that's great news

jamesbuckley

Hi @Dan_J

Saw the changelog for 10.13.16.3650 included the following...

Fixes

• Fixed an issue where tabs would not restore when connection was of Active Directory Password type.

Was this the bug fix for the above?

If so, it's not just the Active Directory Password authentication that is an issue, we are using
Azure Active Directory - Integrated
and still having the issue

Cheers,

Dan_J

Hi @jamesbuckley

I'm sorry this hasn't fixed the issue for you! 

I've gone back to our development team on this and will come back to you as soon as I have an update.

Dan_J

Hi @jamesbuckley

Just to update you that I'm continuing to keep an eye on our development team's progress on this and will come back to you as soon as I have more for you.

Thanks for your on-going patience with us on this!

jamesbuckley

Hi @Dan_J

No problem, its a nuisance more than a problem, so I understand if it's not prioritised.

Cheers,

Dan_J

Hi @jamesbuckley

Appreciate your continued patience with us on this. I hoping to have an update for you soon.

Dan_J

Hi @jamesbuckley

Thanks for your on-going patience with us on this. I appreciate I said this in my last update also, but I'm hoping to have an update for you on this shortly.

In the mean time, our development team have asked if you could confirm if this issue also occurs for you when connecting via Azure AD Integrated?

jamesbuckley

Morning @Dan_J,

Yes, we're using Azure AD Integrated, it's on the comment above from October 30, 2023 9:53AM.

Dan_J

Hi @jamesbuckley

Thanks for your on-going patience with us on this. 

I'm continuing to keep a close eye on progress made on this by our development team and will come back to you as soon as I have more for you.

jamesbuckley

Hi @Dan_J

It is a bit of an annoyance that it was meant to be resolved with a fix in October which didn't work, and is now not being looked at 5 months later but it is what it is.

Cheers,

James