Symptoms

Error “Could not load file or assembly ‘Microsoft.SqlServer.SqlClrProvider, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its depedencies. The system cannot find the file specified.” is displayed during the installation of the repository.

Alternative error with the same solutions is ‘Could not load file or assembly ‘Microsoft.SqlServer.BatchParserClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. ‘

Explanation

Additional Microsoft components are required in case repository is installed on some legacy SQL Server versions. These components are sometimes missing in Windows.

Solution

NOTICE: Restart is sometimes necessary to complete the installation properly.

For SQL 2008

Check if version 10.0.xxx is mentioned in error message. Install packages according your Windows edition (32 or 64) and processor (X – Intel, IA – Itanium) .

Microsoft SQL Server System CLR TypesX   86
X   64
IA 64
Microsoft SQL Server 2008 Native ClientX   86
X   64
IA 64
Microsoft SQL Server 2008 Management ObjectsX   86
X   64
IA 64

For SQL 2005

Check if version 9.0.xxx is mentioned in error message. Install packages according your Windows edition (32 or 64) and processor (X – Intel, IA – Itanium) .

Microsoft SQL Server 2008 Native ClientX   86
X   64
IA 64
Microsoft SQL Server 2008 Management ObjectsX   86
X   64
IA 64