MS Visual Studio error message with SQL server DB

Asked By AnthonyHernandez 30 points N/A Posted on - 07/20/2011

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.

• Status: Open
• Question Views: 1215
• Answer Count: 2
• Vote Up 2 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by manish0111

Go To Solution

Best Answer

Best Answer

Answered By manish0111 0 points N/A #85313

MS Visual Studio error message with SQL server DB

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.

About manish0111

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 07/22/2011
• Question Category: MS SQL Server

Answered By May Jratr 0 points N/A #85314

MS Visual Studio error message with SQL server DB

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,

About May Jratr

Questions
2

Answers
100

Best Answers
31

• Vote Up 0 Vote Down

• Posted on - 12/18/2012
• Question Category: MS SQL Server