Tuesday, March 16, 2010

Sql Server error - A short note for developer

Yesterday when i was working with VS.Net 2008 I got following error. This happens when I try to make connection string with SQL Server 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"

This error is very strange and i could not resolve it easily. I was working in Windows 7 ultimate. I checked everything but finally got to know the solution. This error happens when u try to connect with sql server 2005. This happened bcoz SQL server did not installed fully. So try to download
1. Microsoft SQL Server System CLR Types
2. Microsoft SQL Server 2008 Management Objects
3. Microsoft SQL Server 2008 Native Client
at
http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en#filelist

I hope this post is useful for every developer!!!

No comments:

Post a Comment