Forum Discussion
Solved
2025 Preview, Polybase unsupported connector location prefix
I've installed the preview version of SQL Server 2025 with Polybase enabled. We're currently using it on SQL Server 2022.
Every variant I've tried to add a datasource results in the same error (e.g.) "'odbc://localhost' contains an unsupported connector location prefix. Refer to product documentation for a list of supported connector location prefixes."
This applies for both odbc:// and sqlserver://
I've also tried different variants with CONNECTION_OPTIONS that both contain a Driver reference of a DSN reference. Everything results in the same error.
Never mind, there are 2 settings to enable polybase. I was checking SERVERPROPERTY ('IsPolyBaseInstalled') but I forgot to also enable it
exec sp_configure @configname = 'polybase enabled', @configvalue = 1; RECONFIGURE;
1 Reply
Never mind, there are 2 settings to enable polybase. I was checking SERVERPROPERTY ('IsPolyBaseInstalled') but I forgot to also enable it
exec sp_configure @configname = 'polybase enabled', @configvalue = 1; RECONFIGURE;