Skip to primary content
Skip to secondary content

server1.dk

Tech Tips

server1.dk

Main menu

  • Home

Tag Archives: azure sql

Add Azure Active Directory user to Azure SQL

Posted on May 7, 2020 by Henrik
Reply

First of all, you need to add an Azure Active Administrator to the SQL

In SQL studio to add user/groups:

CREATE USER [Team_xyz] FROM EXTERNAL PROVIDER;
EXEC sp_addrolemember db_owner, [Team_xyz];
Posted in Uncategorized | Tagged azure ad, azure sql | Leave a reply
Recommended by server1.dk

Tags

  • 32bit
  • 64bit
  • Active Directory
  • ad
  • array
  • Azure
  • azure ad
  • azure sql
  • cmd
  • costcenter
  • curl
  • datalake
  • data lake
  • Exchange
  • Exchange 2016
  • gateway
  • hashtable
  • integer
  • linux
  • network
  • ntttcp
  • nuget
  • phishing
  • ping
  • policy
  • ports
  • power bi
  • powershell
  • print
  • public folder
  • random
  • remote
  • Roles
  • rsat
  • sms
  • sql
  • SSL
  • string
  • tags
  • tcp
  • text message
  • windows
  • Windows 10
  • windows server
  • Windows Update

Recent Posts

  • New-AzSubscriptionAlias fails August 18, 2023
  • Get Azure cost for subscription including marketplace expenses with PowerShell July 21, 2023
  • Add program to start up, when you login July 21, 2023

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress