October 22, 2016 at 7:26 am
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.
October 31, 2016 at 7:48 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply