I have an environment where a cloud based server is hosting a SQL Database. Users connect directly to this in order to run queries and download data.
Rather than setting up user logins and assigning them to roles manually I'd like to inherit these from the company Active Directory account. I can get LDAP credentials on the remote SQL Database but I'm unclear on how I can use this to provide login access for the users (and to correctly assign them to roles).
Many thanks.
You can do it with the help of SSIS. Please check the below link for the same. Importing data from Active Directory Using SSIS