Resolving the error 'Could not load file or assembly 'Microsoft.SqlServer.Types, Version=10.0.0.0'

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.

User-added image

User-added image

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.

Additional Information

Microsoft SQL Server 2008 Service Pack 4 Feature Pack
https://www.microsoft.com/en-us/download/details.aspx?id=44277