Share via

Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0

  • Article

Question

Monday, July 29, 2013 3:49 PM

Hi,

I currently installed VS 2012 Ultimate Edition, Visual Web Developer 2012 Express Edition and MS Sql server 2008 R2.

When i go to add a data connection (sql server 2008 r2) in Visual studio 2012.

The steps followed were:

1. Open Server Explorer.

2. right click on Data Connections

3. Click on Add Connection

4. In Choose data source: Microsoft Sql Server and Data Provider: .net framework data provider for sql server

5. Add server name: ALVI\SQLEXPRESS and the database name: Customer

6. Click test Connection: i have got the message: "Test Connection Succeeded"

7. Click OK

"unable to add data connection. could not load file or assembly 'microsoft.sqkserver.management.sdk.sfc' verision=11.0.0, culture=netural, publickkeytoken=89845dcd8080cc91' or one of its dependenciec. The System cannot find the file specified."

I have already tried this method.

1) Microsoft SQL Server Management Objects
2) repair installed on Microsoft SQL Server System CLR Types

3) Microsoft SQL Server 2008 Native Client.

what's the problem? and what i need to do?

Thanks

ALVI

All replies (5)

Wednesday, July 31, 2013 8:42 AM ✅Answered | 1 vote

Hello,

Thank you for your post.

In order to check if the issue is related to your VS, you could locate to the IDE folder then run these commands to check if it can help if you add a data connection in VS2012 Ultimate:

  • Please open Windows Explorer, and navigate to  <Visual Studio Installation Path>\Common7\IDE
  • Devenv.exe /SafeMode: Launches the IDE in safe mode loading minimal windows.
  • Devenv.exe /ResetSettings: Restores the IDE's default settings, optionally resets to the specified VSSettings file.
  • Devenv.exe /ResetAddin: Removes commands and command UI associated with the specified Add-in.
  • Devenv.exe /ResetSkipPkgs: Clears all SkipLoading tags added to VSPackages.

And I did some search about this error and find a thread with the similar issue:

http://social.msdn.microsoft.com/Forums/en-US/efb83302-386b-460f-9467-edce28d61016/unable-to-add-a-data-connection-in-visual-studio

As VMzaure said, if you are using SQL Server Express, you need to specify the server name as MyComputerName\SQLEXPRESS. But based on your post, I feel you are using SQL Server. If you are using SQL Server and have named instance, please try to specify the server name as MyComputerName\InstanceNameHere to check the result.

If still no help, according the error, it indicates that the problem is that the system cannot locate the right assembly (SQL Server SDK). So I think you may get better response and solutions if you consult on SQL Server forums.

Thank you for your understanding.

Best regards,

Amanda Zhu
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Monday, July 29, 2013 5:38 PM

Any body help please

Alvi

Wednesday, August 7, 2013 1:52 AM

Hello,

I am marking useful reply as answer. If the suggestion can’t help you, you can come back and unmark it as answer. If you have anything unclear, please feel free to come back and ask me.

Best regards,

Amanda Zhu
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Monday, July 21, 2014 1:13 PM | 1 vote

Don't follow the above instructions. Crashed my Visual Studio. "cannot find some of the components. Please Reinstall Visual Studio 2012".

I hate you. NKT!

Monday, April 20, 2015 5:56 PM | 1 vote

This is not the answer. I don't think the moderator even read the question.