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=10.0.0.0, 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)

https://www.microsoft.com/en-us/download/details.aspx?id=52676

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

https://www.microsoft.com/en-us/download/details.aspx?id=53164

Microsoft SQL Server 2014 Feature Pack (Version: 12.0.0.0)

http://www.microsoft.com/en-us/download/details.aspx?id=42295

Microsoft SQL Server 2012 SP1 Feature Pack (Version: 11.0.0.0)

http://www.microsoft.com/en-us/download/details.aspx?id=35580

Microsoft SQL Server 2012 Feature Pack (Version: 11.0.2100.60)

https://www.microsoft.com/en-us/download/details.aspx?id=29065

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

https://www.microsoft.com/en-us/download/details.aspx?id=30440

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

http://www.microsoft.com/en-us/download/details.aspx?id=26728

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

https://www.microsoft.com/en-us/download/details.aspx?id=16978

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

https://www.microsoft.com/en-in/download/details.aspx?id=44277

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

https://www.microsoft.com/en-us/download/details.aspx?id=27596

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

https://www.microsoft.com/en-us/download/details.aspx?id=6375

SQL Server 2008 Service Pack 1 (Version: 10.00.2531.00)

https://www.microsoft.com/en-in/download/details.aspx?id=20302

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

主题: SQLSQL Server
分页:12
转载请注明
本文标题:Could not load assembly ‘Microsoft.SqlServer.Connectioninfo, Version=10.0.0.0, ...
本站链接:http://www.codesec.net/view/530795.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(94)