Could not load file or assembly ' MICROSOFT.SQLSERVER.MANAGEMENT.SDK.SFC, the version=11.0.0.0 system cannot find the file specified.

Environment:

Web server:

ip:192.168.1.32, installed with Visual Studio Premium 2013

Operating system: Microsoft Server R2+SP1

Database server:

ip:192.168.1.33, installing Microsoft SQL Server 2012

Operating system: Microsoft Server R2+SP1

Operation Process:

When you use the wizard SqlDataSource to configure a database connection in vs2013, click Test Connection prompt to succeed when clicking OK times wrong:

---------------------------
Microsoft Visual Studio
---------------------------
Could not load file or assembly ' MICROSOFT.SQLSERVER.MANAGEMENT.SDK.SFC, version=11.0.0.0, Culture=neutral, Publickeytoken=89845dcd8080cc91 ' or one of its dependencies. The system cannot find the file specified.
---------------------------
Are you sure
---------------------------
CLR Types

Workaround:

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

Please select the applicable version of your platform.

After the download is complete, install it on the Web server .

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

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

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