March 8, 2016 at 5:22 am
What is the best way to handle application accounts and user accounts in Azure SQL. SQL Server authentication or Contained user?
Also see Azure AD authentication method which is in preview.
Please provide your thoughts.
Many thanks.
March 8, 2016 at 7:14 am
If you are moving towards a hybrid system with AD inside of Azure, I would pursue that. If all the access is directly from Azure, then you get a choice with either the AD or SQL Logins. As to whether you go with contained SQL Logins or standard, there's not much difference really in my experience within Azure. Probably, in order to maximize the ease of transference between data centers, I'd have a bias towards contained.
"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
March 8, 2016 at 9:15 am
Thanks. Any possibility of using the existing on-premise AD accounts in azure db?
March 8, 2016 at 9:33 am
SQL!$@w$0ME (3/8/2016)
Thanks. Any possibility of using the existing on-premise AD accounts in azure db?
It has to be through a hybrid environment, but yes. It's in preview right now[/url].
"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
March 8, 2016 at 5:27 pm
Thanks.
Does that mean I can login using - 'MYDOMAIN\username' ?
March 9, 2016 at 4:21 am
Yes
"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
March 9, 2016 at 5:41 am
Thanks for the clarification.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply