MS Visual Studio error message with SQL server DB

Asked By 30 points N/A Posted on -
qa-featured

Recently I purchased a new Dell Laptop pre-installed with Windows 7. After finding out that all editions of SQL Server 2005 SP3 and SQL Server 2008 SP1 are supported on Windows 7, I purchased SQL server 2005( SP3) and installed it on my laptop. When I try to open up Visual Studio 2008 and connect to SQL Server database, I get an error message:

Unable to add data connection.
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 not able to add any Database because of this error message. Can anyone help me with this since most of my work depends on this DB connection? I tried logging in as different users but I see the error comes back with any user ID.

I have also checked with the permissions and gave the DB full access, but its still the same.

SHARE
Best Answer by manish0111
Best Answer
Best Answer
Answered By 0 points N/A #85313

MS Visual Studio error message with SQL server DB

qa-featured

My solution to this problem will be:

1. Try using a database like MySQL or Oracle and see if its working correctly. If those are working fine then there is some SQL file missing. Try fixing the missing file and your database will work.

2. You might not be logged in with full administrator privileges.

3. Try uninstalling Visual Studio and SQL and reinstalling it again, hopefully it will work.

4. Last option would be to format the machine to remove any hardware profile issue and reinstalling all the software.

 Hope this will solve your issue.

Answered By 0 points N/A #85314

MS Visual Studio error message with SQL server DB

qa-featured

Hi AnthonyHernandez,

Hope that my message finds you well.

I think that the problem is with SQL server and the system unable to locate it.

Usually the installation in not complete and I think you should reinstall it again.

Another reason may be the installation that you have is incorrect.

You can download the SQL server from one of the following URL’s:

Download Source 1

Download Source 2

Download Source 3

Hope that this will help you.

Thanks,

Related Questions