locked
SA User in Azure Database RRS feed

  • 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

    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

    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


    Monday, August 28, 2017 5:19 PM