Today when I tried to connect my application(which is in visual studio 2010) with SQL server 2005 as a database. I've got the following error in my application due to which I was unable to proceed further.
Error/Exception:-
Often you have seen this "Could not load file or assembly" kind of error and In my case, it was "‘Microsoft.SqlServer.Management.Sdk.Sfc, Version=X.x.x.x,(In my case it was 10.0.0.0 version) Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified." error and it is due to some of the missing file i.e. possibly dll or any other file
Solution:
After a bit of researching, I've got the solution that is a pretty simple one because we just need to install three files, and boom it will work. You can download these files from the Microsoft website.
- Microsoft SQL Server System CLR Types
- Microsoft SQL Server 2008 Management Objects
- Microsoft SQL Server 2008 Native Client.
After installing the above three files try to connect your application with the SQL server database and if still, you get the same error message then don't worry and close your application then start it again and you will be able to connect it.
Here are the related links from where I got the solution to this problem and I thought to share it.
http://chiragrdarji.wordpress.com/2009/05/14/could-not-load-file-or-assembly-microsoft-sqlserver-management-sdk-sfc/
http://technologyteams.blogspot.com/2010/05/unable-to-add-data-connection-could-not.html
Hope this post will help you in solving your problem.
Wow!!!
ReplyDeleteHey thanks buddy.
It worked perfectly fine...
Kind Regards
Abhimanyu Kheria
do you know place download
Delete1.Microsoft SQL Server System CLR Types
2.Microsoft SQL Server 2008 Management Objects
3.Microsoft SQL Server 2008 Native Client.
Actually these are included in Microsoft SQL Server Feature Pack but you can also download from microsoft website. or if you have SQL Server Feature Pack then you just need to run the setup and select custom installation.
DeleteEiiiitaaa !!!!!!
ReplyDeletethank man , this helps me a lot
now back to work
thank you very much
Gustavo Hernandez
Thnkx....XXxxx it works...
ReplyDeletePerfect Works...
ReplyDeleteThanks alot..
Hi Aamer Saeed,
ReplyDeleteThanks for the info, very useful but i have a problem. I installed sucessfully the Microsoft SQL Server System CLR Types and Microsoft SQL Server Management Objects, but i can not install the Native Client because it says that I already have a higher version and i need to uninstall that version to be able to install the new one. The problem is that I can´t find where is the old one file. Could you/someone tell me where is located this file in Windows please?
Many thanks;
Marco
You need to go to control panel and then to add remove programs.
Deletethank sir but where i get those three files
ReplyDeleteYou can download these files from Microsoft website.
Deletethank you but where i get those three files
ReplyDelete