May 18, 2015 at 3:40 pm
On an SSAS 2008 server, all of our cubes on it use SQL Server Native Client 10 as their data source type for their Data Sources. The underlying SQL Server version matches this. Recently our cubes began failing during processing (either from an automated job, or on request, i.e. right-click -> process)
When I open their data sources, and right click and choose Properties, then click the ellipsis (...) on Connection String, I get the following error:
The specified provider is not supported. Please choose different provider in connection manager.
This is followed by the opportunity to change the Data Source. The only relevant providers available after that point are:
.Net Providers:
-- SqlClient Data Provider
Native OLE DB:
-- Microsoft OLE DB Provider for SQL Server
-- SQL Server Native Client 11.0
But when I use any of those I get strange errors during processing that I know aren't valid.
I know that SQL Server Native Client 10.0 is the actual valid provider, because when I move the cube to another SSAS server, and process it with the same settings, it works fine.
(Please move this to the correct forum if I'm in the wrong one, or let me know how to do it)
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply