How to add a SQL Account with dbmanager role in Azure SQL

• yyang4

  SSC Veteran

  Points: 235

  More actions

  October 22, 2016 at 7:26 am

  #318296

  I setup the virtual SQL server and a SQL database instance in Azure, and imported an existing database to SQL server in Azure. On my local machine, I have a Window account as DB owner (let's call it userA) and another SQL account (let's call it userB) that can perform CRUD. After import database to Azure, I only see one SQL account with read & write permission. (I am not using Active Directory in Azure)

  Now, I have to use account "userB" to connection SQL DB in Azure. But, this account has not permission to create new DB table. I would like to setup another SQL account with dbmanager role. But, I could not figure out how to do it.

  In Azure portal, after selecting my SQL version server from the resource list, I clicked the "Access control" and added an account with "Owner" role. Still, I am unable to use this account to connection to SQL DB in Azure.

  Any help of resolving this issue will be greatly appreciated.

• Grant Fritchey

  SSC Guru

  Points: 399058

  More actions

  October 31, 2016 at 7:48 am

  #1909621

  Here's a blog post [/url]from Microsoft on how to do this if you're not using AD. It's a little old, but the process is the same. You'll need to connect using a tool that can run T-SQL. You can't do it all from the portal.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning