Resolving the error 'Could not load file or assembly 'Microsoft.SqlServer.Types, Version=10.0.0.0'
book
Article ID: KB0071795
calendar_today
Updated On:
Products
TIBCO Cloud Integration - Connect ( Scribe )
Description
Issue: Customers may experience the error below while trying to run their app/flow or previewing data.
Error: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Issue/Introduction
This article provides the steps on how to resolve the error 'Could not load file or assembly 'Microsoft.SqlServer.Types, Version=10.0.0.0'.
Resolution
- To resolve the error above, check the folder "C:\WINDOWS\ASSEMBLY\C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.Types" to see if the SQL Version=10.0.0.0 (SQL Server 2008) is installed. Install the four (4) files from the Microsoft SQL Server 2008 Service Pack 4 Feature Pack below:
- ENU\x64\SQLSysClrTypes.msi for the X64 version - ENU\x86\SQLSysClrTypes.msi for the X86 version - ENU\x64\SharedManagementObjects.msi for the X64 version - ENU\x86\SharedManagementObjects.msi for the X86 version
- After the files above have been installed, navigate to the folder "C:\WINDOWS\ASSEMBLY\C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.Types" to ensure that Version=10.0.0.0 (SQL Server 2008) is present.
- Restart the TIBCO Scribe On-premise agent, reset the SQL metadata, and preview data.