we had an issue with reporting services for a third party application we use. to fix it reporting services instance had to be redeployed, IIS virtual directory recreated, we got back online. However the Report builder portion doesn’t seem to be working now. Using the third party reporting model, i build a report in the MS report builder GUI and when i try to run it i get the following error
+++++++++++++++++++++++++++++
An attempt has been made to use a data extension ‘SQL’ that is not registered for this report server.
—————————-
Cannot create command for data source ‘dataSource1’.
—————————-
An error has occurred during report processing.
+++++++++++++++++++++++++++++
I checked the rsreportserver.config file and it does have the SQL extenstion correctly defined under the and
Some specs about the server.
SQL2005 standard SP3 running on Win2k3 Ent. R2
8GB memory.
running two report instances.
I’m not sure what else to check here. any suggestions are greatly appreciated. Thanks in advance
