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?
Windows Server 2012 does not provide azure AD join. The only option is ADDS and your adding a lot of complications there with network security and would need to do a VPN of some kind if you wanted to get that working. I think 2019 will support azuread join or does not sure but def. not 2012.
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.