Jan 09 2019
- last edited on
Jan 14 2022
Have been struggling with SQL 2014 on a non-domain Windows 2012 Standard server. I cannot get NTLM Fallback (non Kerberos) authentication to work. Error log of SQL indicates I am trying to use SQL auth when I am giving local server Windows creds. As a test I want to join the server to our O365 tenant and use the Accounts in the tenant to authenticate with. I have already tried using same account name and password on client and server with limited success. The test would allow using Integrated WA if I can get Server joined to Azure AD (O365).
I have installed the AutoWorkplace join program and signed into the Office portal with my Global Admin creds but I cannot figure out how to actually get the server to join the Azure AD.
I have also tried using the Change Computer app in properties but it complains with ldap DNS record not found. NSLOOKUP seems to find the records required for Windows 10 and BYOD services.
Any clues as to how to get a 2012 stand-alone server joined to a O365 tenant?
Jan 09 2019 12:12 PMSolution
Jan 10 2019 10:36 AM
Bummer! Thanks @Chris Webb. Not going to set up another server to do ADFS and then sync to Azure AD for a one-off client server app in the office when we are supposed to be ALL CLOUD.
I worked around by using VPN to office and making local accounts on the server for the users and client app. Sucks for the users as they now have 2 more credentials that I have to manage. Luckily there is only 5 or so.