Symptoms
The below warning message appears when creating a report in the Administration and Monitoring Console:
Could not load file or assembly 'Microsoft.SqlServer.Types, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies.
Cause
There are components required for this feature to work.
Resolution
- Download and install Microsoft System CLR Types for SQL https://www.microsoft.com/en-us/download/details.aspx?id=53164 (choose ENU\x64\SQLSysClrTypes.msi from the list)
- Download and install Microsoft Report Viewer 2015 from https://www.microsoft.com/en-us/download/details.aspx?id=45496
- Reboot the server with the FlexiCapture 12.
Comments
2 comments
Najmi Rafiq
Hello,
Thank you for the article. I would like to point out a small typo. You wrote "ENU\x64\SQLSysOTypes.msi", but it should have been "ENU\x64\SQLSysClrTypes.msi". Please correct it.
Best regards,
Najmi Rafiq
Edward Murphy
Any suggestions for this error is the customer is using Azure SQL DB 2019?
Please sign in to leave a comment.