question

sakuraime avatar image
0 Votes"
sakuraime asked OuryBa-MSFT edited

SSMS Azure Active directory -Integrate

Are there any demo/ video / tutorial for a end-to-end setup , so that the ssms can use 'Azure Active Directory - Integrated' method to login Azure sql database

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

learn2skills avatar image
0 Votes"
learn2skills answered

Hi @sakuraime

Refer to the below url it is explained.
https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/azure-sql/database/authentication-mfa-ssms-configure.md


If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT edited

Hello @Sakuraime, The document shared above by learn2skils explained that. In addition to that If you want to use AAD Integrated, you have to be domain join. Otherwise it won't work. Please let us know if you have further questions. Thanks
Oury

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HI I followed the step and got the following error

100121-error.jpg


100083-version.jpg


0 Votes 0 ·
error.jpg (58.3 KiB)
version.jpg (69.8 KiB)
NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered OuryBa-MSFT commented

Hey,
In order to use AD integrated auth, ADFS must be enabled in Azure AD.
So please verify whether ADFS is enabled or not :

1) login to this URL https://portal.azure.com/#blade/Microsoft_AAD_IAM/DirectoriesADConnectBlade
and check whether federation is enabled or not

https://stackoverflow.com/questions/65662072/connection-to-azure-sql-via-active-directory-integrated

· 9
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

my computer is already joined the Azure AD , and also login successfully as AAD account , is it ok too ?

0 Votes 0 ·

and yes I see Federation is also enabled .

0 Votes 0 ·

@Sakuraime, can you please quick on show details so I can see the error message. Thanks
;

0 Votes 0 ·
Show more comments