SA user password

Question

Hello Professionals

I just setup my first sql server database on azure online but cannot use "sa" as a database user, but my application connection default (fixed) user is "sa" only.

Please how can i get the password for "SA" or create the "sa" account for my database

thank you

Answer 1

Hi @RIDEE COMPUTER

How about create a SQL authentication login, add a user mapped to it in master and add the user to a server level admin role.

Refer to this article for more details: Adding Users to Azure SQL Databases.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

As far as I know there is no sa in Azure SQL Database, and in any case using sa as an application login is very bad practice. An application login should ideally only have permission to run stored procedures, and never more than SELECT/INSERT/UPDATE/DELETE permissions.

Answer 3

Hi @RIDEE COMPUTER

For Azure SQL Server, you can retrieve the Server Admin from the portal, and if you are not aware of the password, you can reset it if you are the owner

Snippet below-

Thank you!