ERROR: An attempt has been made to use a data extension 'SQL' that is not registered for this report server.
PROBLEM:
When you try to run a report (or) Generate a model from an existing Data Source (or) Open a Model using Report Builder from the Report Server, you get the following error,
An attempt has been made to use a data extension 'SQL' that is not registered for this report server.
ROOT CAUSE:
One possible cause of this issue is that the registered SQL extension in your report server config file would have got modified / removed.
SOLUTION:
Open RsReportServer.config file located under <installation path of reporting service> / reportserver folder.
Locate the element,
And make sure it is there as below,
<Extensions> <Data>
<
Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,
Microsoft.ReportingServices.DataExtensions"/>
<
SemanticQuery>
<
Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,
Microsoft.ReportingServices.SemanticQueryEngine">
Comments
Anonymous
March 20, 2009
PingBack from http://blog.a-foton.ru/index.php/2009/03/21/error-an-attempt-has-been-made-to-use-a-data-extension-sql-that-is-not-registered-for-this-report-server/Anonymous
June 30, 2016
Simple fix. This error happens if you have an old DataSet created with an RDLC report. I had this happen when I did not delete my old dataset after making my new one for the converted report as an .RDL. Hope this helps!