Windows 10: Issues with SSMS windows authentication between AADDS and Azure AD.

Discus and support Issues with SSMS windows authentication between AADDS and Azure AD. in Windows 10 Gaming to solve the problem; Hi,My setup is the following:1: All servers Including SQL have been migrated to our Azure Active Directory Domain service name.com2: Our on premise... Discussion in 'Windows 10 Gaming' started by Fullmetal747, Jun 3, 2022.

  1. Issues with SSMS windows authentication between AADDS and Azure AD.


    Hi,My setup is the following:1: All servers Including SQL have been migrated to our Azure Active Directory Domain service name.com2: Our on premise domain is name.local with only laptops still joined to our on prem.3: Planning to join all laptops to Azure AD via Endpoint manager Intune But when I tested this on a new laptop via MDM. SSMS still wanted to authenticate with local Domain\ for windows authentication which did not work.4: I've confirmed the primary domain on Azure AD is name.com but for some reason it still wants to authenticate on SSMS with name.local auth

    :)
     
    Fullmetal747, Jun 3, 2022
    #1
  2. Nikhar_K Win User

    Azure AD Banned Password List without On-Prem Agent

    Hi,



    Thank you for writing to Microsoft Community Forums.



    I understand your query regarding Azure AD Banned Password list without On-Prem agent.



    We do have a dedicated forum for issues concerning to Azure AD, let me point you in the right direction, where you may find appropriate support for the issue. I would suggest you to post your query in
    Microsoft Q&A, where we have support professionals to address your query.



    Article for reference:





    I hope your query gets resolved at the earliest.



    Regards,

    Nikhar Khare

    Microsoft Community - Moderator
     
    Nikhar_K, Jun 3, 2022
    #2
  3. Entegy Win User
    Azure Authenticator or Authenticator?

    Both work, Azure Authenticator is the more recent one. If Azure Authenticator is working for all your accounts, use that.
     
    Entegy, Jun 3, 2022
    #3
  4. Issues with SSMS windows authentication between AADDS and Azure AD.

    Unable to disconnect from Azure AD after account login issues

    Been having an issue with one of our systems that is Azure AD joined, we seem to be experiencing the issue with accounts claiming that the password is incorrect. We are running and Insider Preview build (18346.19h1) on this system, so know to expect a couple
    of issues, but wanted to get others thoughts on it before we reload the system.

    Steps taken so far are:

    • try other Azure Users, same error
    • create and login with a local account
    • disconnect and reconnect to Azure AD
    One of the issues being that we cannot disconnect the system. The disconnect button warns of the consequences, then proceeds to do nothing.

    Any other troubleshooting steps to try or is it time to wipe and reload?
     
    richardthompson21, Jun 3, 2022
    #4
Thema:

Issues with SSMS windows authentication between AADDS and Azure AD.

Loading...
  1. Issues with SSMS windows authentication between AADDS and Azure AD. - Similar Threads - Issues SSMS authentication

  2. Windows Authentication for SQL MI from SSMS

    in Windows 10 Gaming
    Windows Authentication for SQL MI from SSMS: Is this link Complete: Configure Windows Authentication with Microsoft Entra ID - Azure SQL Managed Instance Microsoft Learn ? --I did all the steps mentioned above.But I see another link where it mentions - Configure group policy- where this has to be done ? How to set up...
  3. Windows Authentication for SQL MI from SSMS

    in Windows 10 Software and Apps
    Windows Authentication for SQL MI from SSMS: Is this link Complete: Configure Windows Authentication with Microsoft Entra ID - Azure SQL Managed Instance Microsoft Learn ? --I did all the steps mentioned above.But I see another link where it mentions - Configure group policy- where this has to be done ? How to set up...
  4. Can't use powershell to connect to Azure AD with a Google authentication account

    in Windows 10 Gaming
    Can't use powershell to connect to Azure AD with a Google authentication account: Hi there, I'm trying to connect my powershell to Azure AD. After inputting connect-azuread and inputting my account in the pop-up browser, there will be an error message from Google at last. I tried to use the credential from a successful command connect-azaccount but it's...
  5. Azure AD

    in Windows 10 Gaming
    Azure AD: Hello there, If I have to install a software in 100 Laptop, how can I do it without have on promise Active Directory https://answers.microsoft.com/en-us/windows/forum/all/azure-ad/7657e31f-c97e-4524-9196-faebcf264e84
  6. Azure AD

    in Windows 10 Software and Apps
    Azure AD: Hello there, If I have to install a software in 100 Laptop, how can I do it without have on promise Active Directory https://answers.microsoft.com/en-us/windows/forum/all/azure-ad/7657e31f-c97e-4524-9196-faebcf264e84
  7. Window 10 Azure Ad computer login issues

    in Windows 10 Installation and Upgrade
    Window 10 Azure Ad computer login issues: We have now had 4 machines with issues having no login screen showing after a reboot of their device and install of the June 2022 patch. In this release they stated there is an issue with ARM devices and the logins but I do not have ARM devices. At this moment we have been...
  8. Window 10 Azure Ad computer login issues

    in Windows 10 Gaming
    Window 10 Azure Ad computer login issues: We have now had 4 machines with issues having no login screen showing after a reboot of their device and install of the June 2022 patch. In this release they stated there is an issue with ARM devices and the logins but I do not have ARM devices. At this moment we have been...
  9. Window 10 Azure Ad computer login issues

    in Windows 10 Software and Apps
    Window 10 Azure Ad computer login issues: We have now had 4 machines with issues having no login screen showing after a reboot of their device and install of the June 2022 patch. In this release they stated there is an issue with ARM devices and the logins but I do not have ARM devices. At this moment we have been...
  10. Issues with SSMS windows authentication between AADDS and Azure AD.

    in Windows 10 Software and Apps
    Issues with SSMS windows authentication between AADDS and Azure AD.: Hi,My setup is the following:1: All servers Including SQL have been migrated to our Azure Active Directory Domain service name.com2: Our on premise domain is name.local with only laptops still joined to our on prem.3: Planning to join all laptops to Azure AD via Endpoint...