I've been using the Polybase services in SQL Server 2016 all throughout the pre-release period without any issue.
When I tried using them in the GA (Generally Availability) release, I could never get the two Polybase services to start. They were always stuck in a "Change Pending" state. Trying to start them in SQL Server Configuration Manager basically made SSCM look like it was hung.
Trying to use the Polybase services to create an external data source returned:
TCP Provider: No connection could be made because the target machine actively refused it.
Fellow MVP John Paul Cook came to the rescue today. He previously had an issue with TCP Chimney support and noted that it looked similar.
True enough, the problem was that TCP wasn't an enabled protocol on my SQL Server install on my machine. Enabling TCP and restarting made all good.
Thanks John !
Make that former MVP and now Microsoft employee.
Too true! So used to John being an MVP for so long ! But he still participates in our mailing lists 🙂
I wish I would have spelled my name correctly.
We know who you are 🙂
Greg / John, you saved my bacon with this post. SQL 2016 Dev Edition install with all services at default, couldn't stop the main MSSQL Service and config manager hung. Finally noticed the "change pending" on polybase and turns out this service issue was causing the consequential MSSQL service hanging during requests to stop it but with no error messages.
Enabled TCP and boom! Working as expected.
Cheers for blogging guys 🙂