Asked by:
SA User in Azure Database

Question
-
Good Morning,
We are trying to enable the SA user in our Azure MSSQL DB. It states we do not have appropriate permissions or the item does not exist. We are signed in with the admin account that was created during the database setup. In reading the articles provided by azure, it states that the admin user has restricted permissions in the master DBO group. How do we enable/utilize the SA account?
Best Regards
- Moved by JasonHowellMicrosoft employee Monday, August 28, 2017 4:14 PM wrong forum
Monday, August 28, 2017 3:47 PM
All replies
-
Good morning,
The correct phrase of the referenced Azure Article states "Currently, the SQL Azure portal does not allow you to administrate additional users and logins, in order to do this you need to use Transact-SQL." Learn more, https://azure.microsoft.com/en-us/blog/adding-users-to-your-sql-azure-database/
Christine Sindelar
Monday, August 28, 2017 3:57 PM -
In utilizing T-SQL to try and enable the SA user; we receive a "because it does not exist or you do not have permission error." Mind you, this TSQL update is being launched from the master DBO, with the admin user created at the database setup. If we try to add that user into the sysadmin group with EXEC sp_addrolemember 'sysadmin', 'username'; we get the same does not exist or you do not have permission error.Monday, August 28, 2017 4:16 PM
-
Is the SA admin user the same as your Azure global admin for the portal?
Christine Sindelar
Monday, August 28, 2017 4:19 PM -
The admin account we are using is the account admin name that shows up for the database in the portal(I am not sure if that answers your question or not?) We've also tried turning on the azure AD and assigning an admin account there as well, which had the same issues with permissions.Monday, August 28, 2017 4:21 PM
-
Your issue may be the version of SQL Server that you are deploying to the portal. Learn more, https://msdn.microsoft.com/en-us/library/cc707782(v=sql.120).aspx
- Edited by Christine Sindelar Monday, August 28, 2017 4:42 PM Clarity
- Proposed as answer by Christine Sindelar Monday, August 28, 2017 4:54 PM
- Unproposed as answer by Magnum Dampier Monday, August 28, 2017 5:03 PM
Monday, August 28, 2017 4:34 PM -
We are utilizing the Azure SQL V12 as a service, so I do not believe this article covers the version we are on.Monday, August 28, 2017 5:03 PM
-
Hello,
Your sa account in SQL Azure is the admin account you created during setup of SQL Azure server. That’s your sa account.
Hope this helps.
Regards,Alberto Morillo
SQLCoffee.com- Edited by Alberto MorilloMVP Monday, August 28, 2017 5:19 PM
- Proposed as answer by Estienne GranetMicrosoft employee Tuesday, August 29, 2017 12:00 AM
Monday, August 28, 2017 5:19 PM