Azure SQL Database
An Azure relational database service.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
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!
SA user password
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 25%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
RIDEE COMPUTER
0
Reputation points
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
Azure SQL Database
SQL Server | Other
-
Olaf Helper 47,616 Reputation points2023-09-29T07:38:56.9866667+00:00 What for a Azure database excatly?
- VM with SQL Server
- Azure SQL Database
- Azure Managed SQL Server
-
RIDEE COMPUTER 0 Reputation points
2023-09-29T15:43:57.7833333+00:00 Okay Olaf, Azure SQL Database I created online.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SSingh-MSFT 16,461 Reputation points Moderator2023-10-05T05:54:42.3333333+00:00 Hi
RIDEE COMPUTER •,Just checking in to see if the below answers helped. If this answers your query, do click
Accept AnswerandMark Helpfulfor the same. And, if you have any further query do let us know.
Sign in to comment
3 answers
Sort by: Most helpful
-
Erland Sommarskog 133.6K Reputation points MVP Volunteer Moderator2023-09-29T14:43:02.5166667+00:00 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.
-
LiHongMSFT-4306 31,621 Reputation points2023-09-29T07:26:25.04+00:00 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.