Deploying Data Processing Extension to Report Designer

I have a problem getting my reports working in the designer in vs.net
2005. I have migrated a sql server 2000 report server project to 2005
and added my custom data processing extension to the config files. The
reports works in the report server but although I have added data
extension to both RSReportDesigner.config and given it full trust in
RSPreviewPolicy.config in much the same way as in the reportserver
config files I cant get it to work.
This is my entry in the RSReportDesigner.config in the Data Section:
<Extension Name="HM_SQL_3"
Type="HM.IPS.Report.DataExtension.PermissionProvider.Connection,
HM.IPS.Report.DataExtension"/>
And this is my entry in the RSPreviewPolicy.config:
<CodeGroup class="UnionCodeGroup" version="1"
PermissionSetName="FullTrust" Name="HM_IPSPermission3"
Description="Group for HM DataExtension3">
<IMembershipCondition
class="UrlMembershipCondition" version="1"
Url="C:\Program Files\Microsoft Visual
Studio 8\Common7\IDE\PrivateAssemblies
\HM.IPS.Report.DataExtension.dll"/>
</CodeGroup>
and I still get :
an attempt has been made to use a data extension 'HM_SQL_3' that is
not registered for this report server
when I try to preview reports.
Does anyone have any idea what to try next? This worked flawlessly in
vs.net 2003 and as mentioned before it works when I use the Report
Server through the web.On Apr 11, 6:52 am, jonas.rosqv...@.ecru.se wrote:
> I have a problem getting my reports working in the designer in vs.net
> 2005. I have migrated a sql server 2000 report server project to 2005
> and added my custom data processing extension to the config files. The
> reports works in the report server but although I have added data
> extension to both RSReportDesigner.config and given it full trust in
> RSPreviewPolicy.config in much the same way as in the reportserver
> config files I cant get it to work.
> This is my entry in the RSReportDesigner.config in the Data Section:
> <Extension Name="HM_SQL_3"
> Type="HM.IPS.Report.DataExtension.PermissionProvider.Connection,
> HM.IPS.Report.DataExtension"/>
> And this is my entry in the RSPreviewPolicy.config:
> <CodeGroup class="UnionCodeGroup" version="1"
> PermissionSetName="FullTrust" Name="HM_IPSPermission3"
> Description="Group for HM DataExtension3">
> <IMembershipCondition
> class="UrlMembershipCondition" version="1"
> Url="C:\Program Files\Microsoft Visual
> Studio 8\Common7\IDE\PrivateAssemblies
> \HM.IPS.Report.DataExtension.dll"/>
> </CodeGroup>
> and I still get :
> an attempt has been made to use a data extension 'HM_SQL_3' that is
> not registered for this report server
> when I try to preview reports.
> Does anyone have any idea what to try next? This worked flawlessly in
> vs.net 2003 and as mentioned before it works when I use the Report
> Server through the web.
This link might be helpful (refer to Bryan E's final response):
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/e1289b66066a07b9/0ba37f7653d8a851?lnk=st&q=an+attempt+has+been+made+to+use+a+data+extension+that+is&rnum=1#0ba37f7653d8a851
Regards,
Enrique Martinez
Sr. Software Consultant