question

PulipatiVedanth-8342 avatar image
2 Votes"
PulipatiVedanth-8342 asked 02137510 commented

Not able to generate credentails for Azure SQl Database

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://docs.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..!!

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.

SaurabhSharma-msft avatar image
3 Votes"
SaurabhSharma-msft answered SaurabhSharma-msft commented

Hi @pulipativedanth-8342,
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

`115945-image.png

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



image.png (8.4 KiB)
· 2
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.

Thank's for you, That's help me to ask you about I don't know

2 Votes 2 ·

Hi @pulipativedanth-8342,

I have converted my comments to Answer. Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Thanks
Saurabh

1 Vote 1 ·
SanaaMaroufAlSabaibaa-5068 avatar image
1 Vote"
SanaaMaroufAlSabaibaa-5068 Suspended answered

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

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.