Forum Discussion
Login failed while configuring Azure SQL connector
Hello All, I'm trying to play with the Microsoft Graph connectors and trying to set up my first conector. I decided to use the Microsoft Azure SQL connector and went through the guides in Microsoft...
Hey JonathanYeg,
Please grant permission to your registered app in Azure SQL.
To add the registered app to your Azure SQL Database, you need to:
- Log in to your Azure SQL DB
- Open a new query window
- Create a new user by running the command 'CREATE USER [app name] FROM EXTERNAL PROVIDER'
- Add user to role by running command 'exec sp_addrolemember 'db_datareader', [app name]'
Microsoft Reference - https://learn.microsoft.com/en-us/microsoftsearch/mssql-connector