PolyBase Service Account Permissions and Common Errors Observed When They Are Missing

We have seen a number of PolyBase cases in SQL Server Support related to logins or permissions created and set during installation that are missing. It is quite common for organizations to want to lock down their environment from a security perspective in order to comply with principal of least privilege. Unfortunately, this has resulted in the removal of logins and permissions that are required for PolyBase to function properly.


I want to give a brief overview of the logins and permissions that are required and then highlight a couple of the common issues we’ve seen when these logins