Problem Statement:

When trying to migrate SQL Server 2008 R2 to SQL Server 2016, we identified an issue with the following error:

Could not load assembly ‘Microsoft.SqlServer.Connectioninfo, Version=, Culture=netural, PublicKeyToken=89845dcd8080cc91’ or one
Of its dependencies. The system cannot find the file specified.

As a knee jerk reaction, we initially thought it was an issue with SQL Server 2016 installation and need to install the Feature Pack for SQL Server 2016. Once applied the feature Pack, we again tested and found the same issue unfortunately(but really fortunate one!!!).

Analyzing further(I mean, reading the error message clearly, It is found the version 10.0.0 that represents Microsoft SQL Server 2008.

As we do not have SQL Server 2008 installed in the environment and the code(.NET application) has some reference to the version mentioned, this was not able to find the dlls in the specified path(C:\windows\assemblies\).

To proceed with our testing, we installed SQL Server 2008 R2 Feature pack and resumed our testing. Finally, it worked like a treat!!!

The learning is we always need to go to the facts(error message) than blindly presume things!!!

please find the below information for various version feature pack references:

Microsoft SQL Server 2016 Feature Pack (Version: 13.0.1601.0)

Microsoft SQL Server 2014 SP2 Feature Pack (Version: 12.0.5000.0)

Microsoft SQL Server 2014 Feature Pack (Version:

Microsoft SQL Server 2012 SP1 Feature Pack (Version:

Microsoft SQL Server 2012 Feature Pack (Version: 11.0.2100.60)

Microsoft SQL Server 2008 R2 SP2 Feature Pack (Version: 10.50.4000.0)

Microsoft SQL Server 2008 R2 SP1 Feature Pack (Version: 10.50.2500.0)

Microsoft SQL Server 2008 R2 Feature Pack (Version: 10.50.1600.1)

Microsoft SQL Server 2008 Service Pack 4 Feature Pack (Version: 10.0.6000.29)

Microsoft SQL Server 2008 Service Pack 3 Feature Pack (Version: 10.00.5500.00)

Microsoft SQL Server 2008 Service Pack 2 Feature Pack (Version: 10.00.4000.00)

SQL Server 2008 Service Pack 1 (Version: 10.00.2531.00)

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

主题: SQLSQL Server
tags: SQL,Server,Pack,Version,Microsoft,Feature,download,en,details,microsoft,id,com,aspx
本文标题:Could not load assembly ‘Microsoft.SqlServer.Connectioninfo, Version=, ...

技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(210)