Tabs don't remember connections when using Azure Managed Instance
jamesbuckley
Posts: 10 Bronze 1
in SQL Prompt
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?
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?
Tagged:
Answers
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?
Dan Jary | Redgate Software
Have you visited our Help Center?
It happens on all variations as far as I'm aware.
My SSMS:
SQL Server Management Studio 19.0.20209.0+f9a9d8f6
And SQL Prompt is 10.13.14.2694.
Cheers,
James
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 Jary | Redgate Software
Have you visited our Help Center?
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.
Dan Jary | Redgate Software
Have you visited our Help Center?
Saw the changelog for 10.13.16.3650 included the following...
Fixes
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,
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 Jary | Redgate Software
Have you visited our Help Center?
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!
Dan Jary | Redgate Software
Have you visited our Help Center?
No problem, its a nuisance more than a problem, so I understand if it's not prioritised.
Cheers,
Appreciate your continued patience with us on this. I hoping to have an update for you soon.
Dan Jary | Redgate Software
Have you visited our Help Center?
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?
Dan Jary | Redgate Software
Have you visited our Help Center?
Yes, we're using Azure AD Integrated, it's on the comment above from October 30, 2023 9:53AM.
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.
Dan Jary | Redgate Software
Have you visited our Help Center?
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
Any update on the priority on this?
Thanks,
James
I'm very sorry we're still waiting for a resolution on this.
This is still with our development team currently. I'm chasing this regularly, and have just done so again. I'm continuing to keep a very close eye on progress.
I appreciate this is taking a while, thank you for your patience.
I'll come back to you on this again as soon as possible.
Dan Jary | Redgate Software
Have you visited our Help Center?
My sincere apology again for the on-going wait on this, I appreciate you have been waiting for a fix for this for some time now.
Our team are looking at this, however there have been some delays along the way.
I am continuing to keep a close eye on progress on this and hope to have a better update for you very soon.
Dan Jary | Redgate Software
Have you visited our Help Center?
I appreciate you keeping me updated. This is still an issue and is still annoyance on a day to day basis so the help would be appreciated.