Could not load file or assembly microsoft.sqlserver.management.sdk.sfc

3
votes

Receiving below error message in Visual Studio 2008 while creating a connection for database.

could not load file or assembly 'microsoft.sqlserver.management.sdk.sfc ,Version=10.0.0.0, Culture=neutral,PublicKeyToken=89845dcd8080cc91' or one of its dependencies.
The system cannot find the file specified.

I am trying to create database internally i.e. .mdf file and store it in the App_data folder. But I'm not able to create the connection.

Please help me to sort out the issue quickly.

1
asp.netsql-server
Connection string? Jet driver perhaps? version? Is office or access installed? - user645280
Problem has been now solved by installing below three setups ... Microsoft SQL Server System CLR Types - go.microsoft.com/fwlink/?LinkId=123721&clcid=0x409 Microsoft SQL Server 2008 Management Objects - go.microsoft.com/fwlink/?LinkId=123708&clcid=0x409 Microsoft SQL Server 2008 Native Client - go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409 - user1763769

1 Answers

6
votes

You can download these files from Microsoft website.

1.Microsoft SQL Server System CLR Types

2.Microsoft SQL Server 2008 Management Objects

3.Microsoft SQL Server 2008 Native Client.

After installing the above three files try to connect your application with sql server database and if still you got the same error message then don't worry and close your application then start it again and you will be able to connect it.