Windows 10: 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 Windows authentication for Microsoft Entra ID with the modern interactive flow - Azure SQL Managed Instance Microsoft LearnConfigure group policy Enable the following group policy setting Administrative Templates\System\Kerberos\Allow retrieving the cloud Kerberos ticket during the logon:I am trying to connect to my mana

:)

 

SSMS would not authenticate after installing SQL on domain controller

I am getting 18456 error when trying to log on to sql management studio. i have installed sql on domain controller and i cannot log on neither by windows authentication nor sql authentication

 

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.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.

 

SQL Server events after Windows update last week

Hi EdBeery,

Regardless of your SQL Server version, I would highly recommend you download the latest SSMS here (https://docs.microsoft.com/en-us/sql/ssms/downl...).

As of this writing, it's version 17.4. Microsoft releases a new version of SSMS every month and I would encourage you to download the latest one because Microsoft fixes some bugs and new features are added. The only downside is you need to reboot your machine
every time you update the SSMS.

If you need the SQL Server Database Engine installed on your laptop, you can download it (https://www.microsoft.com/en-au/sql-server/sql-...). You can download SQL
Server Express or SQL Server Developer Edition. I would suggest you download the Developer Edition as it has all the features of Enterprise edition so you can play around with the features of Enterprise.

I hope to help you.