Enable elastics jobs to use managed service identity
SQL Server now supports MSI and yet Elastic Jobs still relies on SQL user credentials. It would be much better to be able to give a job an AD identity that can be managed and can be given rights on certain servers and databases.
71
votes
Nick Verschueren
shared this idea
1 comment
-
Anonymous
commented
With a Powershell Runbook you can use the Acitve Directory admin on Azure SQL Server to run queries over all Azure sql database. If Enable elastics jobs could use the same feature it would make life more easy. To have to create a user and permissions in each database you want to run jobs against is not fun.