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 (2)

  1. Jacob Fortuna says:

    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!

Skip to main content