Azure SQL Database
An Azure relational database service.
Same problem. Started working after re-registering MFA:
Error logging in to Azure SQL Managed Instance using MFA from SSMS
Zrethreal
6
Reputation points
Today when I try to login to a managed sql instance from SSMS using Universal with MFA authentication method is failing. When I press connect in SSMS the popup where I input my password comes up and I enter the password. Then a notification about a script error appears and it never proceeds to the MFA part of authentication. This means I am currently unable to login and manage the instance via SSMS.
This worked yesterday.
Azure SQL Database
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator2021-06-08T19:20:51.123+00:00 Hi @Zrethreal ,
Thanks for using Microsoft Q&A !!
Are you the only one facing this issue. Has anyone else tried connecting using MFA ? Can you try with any other UPNs in current environment ? Also, can you try to login from any other machine.Thanks
Saurabh -
Zrethreal 6 Reputation points
2021-06-08T19:51:45.157+00:00 Hi Saurabh,
Thank you for your reply.
I am the only one in my company using the Azure SQL Managed Instance, so I cannot ask anyone else here or try with another UPN. I have tried logging in from two different machines, one running SSMS 15.0.18384.0 and the other one running SSMS 15.0.18369.0 - both same error with 'includes' method not being supported.
If you think it likely this could be something with the user principal I can ask our admin to set up a test account tomorrow.
For a little more context I can tell you that I can successfully log in from Azure Data Studio using the same account. I can also log into the Azure portal and to this site here. I can also log in to the instance in SSMS using a service account which is set up with regular password authentication (that account does only has read access so it cannot be used as a workaround). So the problem seems to be confined to the Universal with MFA authentication method
/Nicolai -
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
2021-06-08T20:03:35.447+00:00 Hi @Zrethreal ,
Thanks for the clarifications and I was about to ask about Azure Data Studio and I see this works for you. I am checking internally with the products team on the same and get back to you if I get any updates by today. Meanwhile please share your results using another test account once you are done with that tomorrow.
Thanks
Saurabh -
Zrethreal 6 Reputation points
2021-06-09T08:32:13.08+00:00 Hi @Saurabh Sharma ,
I still got this issue. We tried enabling one of my colleagues for the instance and she could log in with MFA. We can see in the log, that we are using different User agents for connecting - I'm on Mozilla/5.0 while she is on Mozilla/4.0
/Nicolai -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 87%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dow Shirley 1 Reputation point2021-06-10T14:20:08.737+00:00 I am seeing this exact behavior in my organization as well. One user is getting the script error and another user (using the same computer) can sign into SSMS successfully. Both users are MFA enabled. The user experiencing the error was able to sign into SSMS last week just fine.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 7.000000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Satya Rao 6 Reputation points2021-06-10T16:05:25.6+00:00 I am getting the same error ("ConvergedSA_Core") from yesterday onwards. And I am the only one having the issue after yesterday's company's Windows Update push.
-
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
2021-06-10T16:43:34.903+00:00 Hi @Dow Shirley @Satya Rao , @nicolailassesen-3872,
I am still following up with the products team to get more information on this issue. I will update you back.
Thanks
Saurabh -
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
2021-06-10T21:15:23.313+00:00 Hi @Dow Shirley @Satya Rao , @Zrethreal ,
Is 15.0.18369.0 is a build number or SSMS version ?
It looks like your SSMS versions are old. Could you please try it using the latest SSMS 18.9.1 version?
See Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Learn
-
Zrethreal 6 Reputation points
2021-06-10T21:27:11.057+00:00 Hi @Saurabh Sharma ,
That is the build number. I’m on the newest version of SSMS (18.9.1)
/Nicolai -
Satya Rao 6 Reputation points
2021-06-10T21:46:26.853+00:00 I confirm that I am also on the same build number.
Sign in to comment
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 20%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pk 11 Reputation points2021-06-11T10:53:40.753+00:00 -
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
2021-06-11T17:28:25.523+00:00 Thanks for sharing @pk
Hi @Dow Shirley @Satya Rao , @Zrethreal ,
Can you guys please check if re-registering resolves issue for you ?Thanks
Saurabh -
Satya Rao 6 Reputation points
2021-06-15T14:41:40.497+00:00 @Saurabh Sharma yes, that resolved my issue. Thanks
-
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
2021-06-15T14:54:21.09+00:00 @Satya Rao Thanks for the confirmation.
-
Zrethreal 6 Reputation points
2021-06-16T17:12:15.387+00:00 As far as I recall re-registering requires setting the Authenticator up all over again, which is quite cumbersome if you have a lot of stuff attached to it, so I'll skip this.
For now I have a work-around for the issue by not requiring two-factor for my account
-
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
2021-06-16T19:34:31.69+00:00 @Zrethreal sure, thanks.
Sign in to comment -