# Azure Active Directory Setup Process

## Introduction

* Azure Active Directory details in DBSync Replication Profile

#### **Using Azure Active Directory For logging in to SQL Server and Azure Synapse** <a href="#azureactivedirectorysetupprocess-usingazureactivedirectoryforloggingintosqlserverandazuresynapse" id="azureactivedirectorysetupprocess-usingazureactivedirectoryforloggingintosqlserverandazuresynapse"></a>

* Go to the database section and select database type as SQL Server./ Azure Synapse

  ![](https://docs.mydbsync.com/~gitbook/image?url=https%3A%2F%2Flh4.googleusercontent.com%2FSKcLwhqLf0kXZDZO3JlFH5sPlpQBgIRMwJUiOex28MgDfWAqKoT6ywg1jNxw8Xnll2Z85pP4hMMjl_uyA32IJWYDtlMChbjh8gSlB8sevprm5wRz45GZRCXkXNAK6OyJtcO8WBiVsQnF5Md9Qj3W5A\&width=300\&dpr=4\&quality=100\&sign=f179c7ca95df5c37508ef88932379ccec85e43b8301bc1edbcdc38bf6aa8ae2a)
* Click On ADD Password Authentication checkbox to use the Active directory for the login process.

  ![](https://docs.mydbsync.com/~gitbook/image?url=https%3A%2F%2Flh3.googleusercontent.com%2Fbzgag6r0gN1_8TFh5vJGh5aWrSmX16brL_fpkxRhgayPyL2OIuZX7iBIQpqdFfxlZ99Ts3-VFTuWvCDzTEByevb8SNGm5shg-FHs2gau6AkOppIDjNMnBMmKEwOHspbHBbWnpziEowbkgJMFk1W-lg\&width=300\&dpr=4\&quality=100\&sign=3d3450bc3d3719e9a385a2f2228d4c480e2488d65d604a3c6186b60298af97f4)
* Enter your Data Base credentials associated with your Azure Active Directory ( check with your admin for your AAD credentials )

  ![](https://docs.mydbsync.com/~gitbook/image?url=https%3A%2F%2Flh3.googleusercontent.com%2Fbzgag6r0gN1_8TFh5vJGh5aWrSmX16brL_fpkxRhgayPyL2OIuZX7iBIQpqdFfxlZ99Ts3-VFTuWvCDzTEByevb8SNGm5shg-FHs2gau6AkOppIDjNMnBMmKEwOHspbHBbWnpziEowbkgJMFk1W-lg\&width=300\&dpr=4\&quality=100\&sign=3d3450bc3d3719e9a385a2f2228d4c480e2488d65d604a3c6186b60298af97f4)
* Test the connection and save it.

  ![](https://docs.mydbsync.com/~gitbook/image?url=https%3A%2F%2Flh6.googleusercontent.com%2F39c1ihz-x06kkpayLKFOwS4NgP00Lv7dyig6KFjlUE7fEeazys6n9Xqfl0KCF_I7zNPsAtFqkTCkryO4i9eTfPQ6sYLvH5C9RkG3A4_OUdZDmVD7AxTcz8LdrUiWI5sAUQS02GHI2X2rpYwZYjsFcg\&width=300\&dpr=4\&quality=100\&sign=b2b1bddf7ab7a7c237f3fd7ed5a72078efe91db61475947987d533241c7c303a)
* Now you can use your SQL server/ Azure Synapse connected through your AAD.