Share via

Issues with SSMS windows authentication between AADDS and Azure AD.

Anonymous
2022-06-03T09:32:37+00:00

Hi,

My setup is the following:

1: All servers ( Including SQL ) have been migrated to our Azure Active Directory Domain service ( name.com)

2: 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 authentication.

Note: We have a PAAS AADDS solution for our name.com Domain for servers which also syncs with our on-prem vir Azure Ad Connect.

Any advise would be greatly appreciated.

Windows for home | Windows 11 | Accounts, profiles, and login

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2022-06-03T10:05:40+00:00

Good Day Fullmetal747,

My name is Carlo, I am also using Windows pc and community member like you.

This is a community forum for Home consumers, for Azure AD and SQL related inquiries you can post it in this forum below.

https://docs.microsoft.com/en-us/answers/produc...

Have a wonderful day ahead and stay safe.

Sincerely,

Carlo T.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful