locked
SA User in Azure Database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    Is the SA admin user the same as your Azure global admin for the portal?

    Christine Sindelar

    Monday, August 28, 2017 4:19 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    1
    Sign in to vote

    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