Unable to Start SQL Server Polybase Engine 2016

Unable to Start SQL Server Polybase Engine 2016

October 5, 2016

After installation the SQL Server PE failed to start with the following errors (found in Event Viewer filtering for the source ESENT):

msmdsrv (9644) An attempt to open the file
“C:\Windows\system32\LogFiles\Sum\Api.log” for read only access failed with system error 5 (0x00000005):
“Access is denied. “. The open file operation will fail with error -1032 (0xfffffbf8).

msmdsrv (9644) Error -1032 (0xfffffbf8) occurred while opening logfile C:\Windows\system32\LogFiles\Sum\Api.log.

This was solved by granting the PE service account appropriate permissions on the OS. In this case, we simply added the domain account we were using to run the server as local administrator.

Igiri Books © Copyright 2016. All Rights Reserved. Site Credits: AppWorld