CODEWITHSUNDEEP
sql-servervisual-studiosql-server-2014visual-studio-exp-2013
luke_t
luke_t

Reputation: 2985

Unable to add data connection

I have SQL Server 2014 installed. When I'm attempting to create a data connection within Visual Studio Express 2013 for Windows Desktop it's giving me the below error.

Unable to add data connection. Could not load file or assembly. Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0, Culture=neutral, PublicKeyToken=[key] or one of its .dependancies. The system cannot find the file specified.

I have downloaded and installed both the .msi files advised in this answer.

Although the answer states that with SQL Server 2014 you should receive the error message stating Version=12.0.0.0, however I'm receiving the error message showing Version=11.0.0.0. Should I maybe download and install the ENU\x64\SharedManagementObjects.msi for SQL Server 2012?

Checking C:\Windows\assembly shows that Microsoft.SqlServer.Management.Sdk.Sfc is installed as version 12.0.0.0.

Upvotes: 1

Views: 10700

Answers (2)

Milad
Milad

Reputation: 11

For both types (32 bit and 64 bit), this works:

  1. Open URL http://www.microsoft.com/en-us/download/details.aspx?id=35580
  2. Download ENU\x86\SQLSysClrTypes.msi
  3. Download ENU\x86\SharedManagementObjects.msi
  4. Install ENU\x86\SQLSysClrTypes.msi
  5. Install ENU\x86\SharedManagementObjects.msi
  6. Restart your Visual Studio and now Everything will work smooth.

See here.

Upvotes: 1

luke_t
luke_t

Reputation: 2985

I downloaded ENU\x64\SharedManagementObjects.msi for SQL Server 2012.

It would appear that when using Visual Studio 2013, and SQL Server 2014, it requires version 11.0.0.0 of Microsoft.SqlServer.Management.Sdk.Sfc.

Upvotes: 2

Related Questions