Share via

Problem running the command

PingpongSet 36 Reputation points
2020-09-08T06:53:16.093+00:00

I am having a problem running the command from the link below:

sqlcmd -S <server-name>.database.windows.net -d <db-name> -U <aad-user-name> -P "<aad-password>" -G -l 30

https://learn.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-connect-msi

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,725 questions
0 comments
Accepted answer
  1. Evgeny Grishchenko 486 Reputation points
    2020-09-08T08:30:12.917+00:00

    I have checked that by assigning the external user to the particular DB, not making this user an admin. It has worked. But without "-P" option.

    What I could suggest:

    • install the latest Microsoft ODBC Driver 17 for SQL Server
    • try your command without "-P" to check the authentication
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.