Couldnotloadfileorassembly & #39; Microsoft. SqlServer

Environment: web server: ip: 192.168.1.32, installed with VisualStudioPremium2013 Operating System: MicrosoftServer2008r2 + sp1 database server: ip: 192.168.1.33, installed with MicrosoftSQLServer2012 Operating System: MicrosoftServer2008r2 + sp1 operation process: benefit in vs2013

Environment: web Server: ip: 192.168.1.32, Visual Studio Premium 2013 Operating System: Microsoft Server 2008 r2 + sp1 database Server: ip: 192.168.1.33, Microsoft SQL Server 2012 operating system installed: microsoft Server 2008 r2 + sp1 operation process: in vs2013

Environment:

Web Server:

Ip: 192.168.1.32, installed with Visual Studio Premium 2013

OperationSystem: Microsoft Server 2008 r2 + sp1

Database Server:

Ip: 192.168.1.33, installed with Microsoft SQL Server 2012

OperationSystem: Microsoft Server 2008 r2 + sp1

Procedure:

When using the wizard SqlDataSource in vs2013 to configure a database connection, click test connection to prompt that the connection is successful. If you click OK, an error is returned:

---------------------------
Microsoft Visual Studio
---------------------------
Cocould not load file or assembly 'Microsoft. SqlServer. Management. Sdk. Sfc, Version = 11.0.0.0, Culture = neutral, PublicKeyToken = 89845dcd80cc91 'or one of its dependencies.SystemNot foundSpecifyOfFile.
---------------------------
OK
---------------------------
CLR Types

Solution:

Go to Microsoft Official Website: http://www.microsoft.com/en-us/download/details.aspx? Id = 29065

Download the following two components:

Microsoft®System CLR Types for Microsoft®SQL Server®2012

Microsoft®SQL Server®2012 Shared Management Objects

Select the applicable version of your platform.

After the download is completeWeb ServerInstall it on.

For your convenience, I have downloaded and shared the following (for the x64 platform ):

Http://pan.baidu.com/s/1hqIIUtY

Http://pan.baidu.com/s/1gdEbp2j