Data Tools 2017 Installing Custom Data Processing Extension

Michael Hartkopf 1 Reputation point
2021-11-24T08:37:51.337+00:00

Hi all,

I have developed a data processing extension years ago, it worked on the old versions with the described deployment without any issues. But the customer updated the SQL Server and with it comes the new visual studio version. (Visual Studio 2017 installed from SQL Setup.)

I don't manage to get the extension run on the machine after following these instructions:
https://learn.microsoft.com/en-us/sql/reporting-services/extensions/data-processing/deploying-a-data-processing-extension-to-report-designer?view=sql-server-ver15

After some research I copied the dll to both folders:
C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\CommonExtensions\Microsoft\SSRS
C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\PrivateAssemblies
(Pathes are now from my local installation where I try to fix this issue. That is why it is Community version of VS. Hope it does not matter.)

I also updated the .net version of my dlls to 4.5.2.

I changed the first codegroup in the RSPreviewPolicy.config to FullTrust to avoid issues there:

<CodeGroup
class="FirstMatchCodeGroup"
version="1"
PermissionSetName="FullTrust">
<IMembershipCondition
class="AllMembershipCondition"
version="1"
/>

I am a little bit lost. Does anyone have an idea what it could be?

Thanks,
Michael

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Isabellaz-1451 3,616 Reputation points
    2021-11-25T01:26:42.193+00:00

    Hi @Michael Hartkopf

    I ran into a similar problem trying to create a Data Processing Extension and finally realized that I was building my extension as a .net 4.0 dll, and ssrs only supports 3.5 (uses 2.0.50727 clr)

    I refer to this thread：https://stackoverflow.com/questions/18226767/sql-server-2008-r2-reporting-service-data-processing-extension-issue

    SSRS is built against the Microsoft .NET Framework 2.0 and the Microsoft .NET Framework 3.5. We recommend that you use .NET Framework 2.0 or .NET Framework 3.5 only in SSRS.

    I refer to this thread：https://support.microsoft.com/en-us/topic/the-net-framework-4-x-assemblies-are-not-supported-in-sql-server-reporting-services-993895a1-4b00-9b34-f1cc-4c1f8219ccd4

    Is it because of that the dll .NET version too high？

    Best Regards,
    Isabella

    If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments