Processing the Reporting Database on SQL Server 2012 Fails with Provider Errors

When processing the Discovery Center Reporting Database, the task may fail with an error in the scheduler log stating that the provider 'SQLNCLI10.1' is not registered.  This error is based on an incompatibility with the provider and the 2012 version of SQL Server.

This article provides steps to resolve this issue.

Resolution

1. Open Microsoft SQL Management Studio.
2. In the "Connect to Server" dialog box, set the connection type to Analysis Services and type in the name of the SSAS server.

   

3. Expand out the Databases node > Active Navigation database node > Data Sources node.
4. You should see one data source ("ActiveNav4" by default).  Right click and select Properties.

   

5. Select the Connection String property under the General section on the right and click the "..." button.  Take note of the server and database name.
   
   
6. Drop down the box that says Provider. If SQL Server Native Client 10.0 is not available, select SQL Server Native Client 11.0
7. Re-enter the server name and re-select the database under "Select or enter a database name:"

   

8. Modifying the connection string will reset the password for the impersonation account, so before closing the data source properties, select the line for Impersonation Info under Security Settings.

   

9. "Use a specific Windows user name and password" should be selected and it should list your current Active Navigation scheduler service account. Re-enter the password for this account and click "OK".

   

10. Click "OK" for the Data Source Properties window.
11. You should now be able to process the reporting database without these errors.
12. If issues persist, we have seen occasions where a restart of the SSAS server is necessary.