Not able to generate credentails for Azure SQl Database

Question

Hi,

I am trying to connect Azure SQl Database using GitHub Actions. but i am not able to generate the deployment credentials.
Referred document for connection: https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-github-actions-sql-db#code-try-0

Stuck at Generate the deployment credentials.

Thanks in advance..!!

Answer 1

Hi @Pulipati Vedanth ,
Thanks for using Microsoft Q&A !!
Are you getting any errors ? I am able to create the service principal using listed cmdlet, however, it looks like the cmdlet in the document has additional bacslash('\') which might be causing error while creating the credentials. Can you please run the cmdlet like below if that's the case -
az ad sp create-for-rbac --name {server-name} --role contributor --scopes /subscriptions/{subscription-id}/resourceGroups/{resource-group} --sdk-auth

`

Please refer to az ad sp create-for-rbac.
Please let me know if you are getting any other errors so that we could help you.

Thanks
Saurabh

Answer 2

Please refer to az ad sp create-for-rbac.
Please let me know if you are getting any other errors

Thanks
Sana'a Al Sabaiba'a

Answer 3

البدء السريع: تواصل مع إجراءات GitHub - قاعدة بيانات Azure لـ MySQL - الخادم المرن