Thursday, October 2, 2008

Visual Studio 2008 Error

SOFTWARE:
Visual Studio 2008 Team Database Edition
SQL Server 2005 Enterprise SP2

ERRORS:
"The database that you selected is not supported"

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 sytem cannot find the file specified.

STEPS TO REPRODUCE:
Data > Schema Compare
New Connection..
Type in all info > select database name (it IS seeing all the
databases on the server)
click Test Connection
"Test Connection suceeded"
Click OK
"The database that you selected is not supported"

Does the same thing if I do
New Project > Visual C# > Database > SQL Server Project
Server Explorer
Add New Connection
Error:
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 sytem cannot find the file specified.

TROUBLESHOOTING STEPS ALREADY TAKEN:
I tried totally uninstalling Visual Studio 2008, 2005, and SQL 2005
Workstation Components/Client Tools..
Installed Visual Studio 2008
Tried same thing, got same error message.
Installed SQL 2005 Workstation Components / Client Tools
Installed SQL 2005 SP2
Tried same thing, got same error message.

SOLUTION: Download and install following from Microsoft.

- Microsoft SQL Server 2008 Native Client
- Microsoft SQL Server System CLR Types
- Microsoft SQL Server 2008 Management Objects

These features can be downloaded from:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en#filelist

Reference: http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.vstudio.general&tid=89ee0e86-b8fc-40a7-a0e1-51ac4033302e&cat=en_US_38f7e3d1-40bd-4daf-941f-f45d2ff6ff9b&lang=en&cr=US&sloc=&p=1

3 comments:

  1. Hi,

    Your solution works perfectly.

    Just I Download and install Native Client, CLR Types, and Management Object.


    Dharmesh R. Makhecha
    Prakash Software Solutions Pvt. Ltd. - Vadodara

    ReplyDelete
  2. I always spent my half an hour to read this blog's articles daily along with a mug of coffee.



    Feel free to visit my homepage: dui attorney portland oregon

    ReplyDelete
  3. My family all the time say that I am wasting my time here at web,
    however I know I am getting knowledge everyday by reading thes good
    posts.

    My weblog :: search engine optimization consultant

    ReplyDelete