VS 2008 Team - Database not supported / Can't load file or assembly   

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:
Unkown

date: Thu, 17 Jul 2008 16:28:15 -0700 (PDT)   author:   Neufusion

Re: VS 2008 Team - Database not supported / Can't load file or assembly   

On Jul 17, 4:28 pm, Neufusion  wrote:
> 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:
> Unkown

Fixed it....
Apparently playing with a SQL 2008 demo in the past caused some DLL
hell.

SOLUTION:
http://forums.msdn.microsoft.com/es-ES/Offtopic/thread/70a5cb26-6b20-43a0-8cef-a0c5716a3e1c/

Install the following from Microsoft SQL Server 2008 Feature Pack RC0,
June 2008 -
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=089A9DAD-E2DF-43E9-9CD8-C06320520B40&displaylang=en

date: Thu, 17 Jul 2008 17:18:47 -0700 (PDT)   author:   Neufusion

Re: VS 2008 Team - Database not supported / Can't load file or ass   

Thank you Neofusion!
Really helped me out.
I would shake your hand,



"Neufusion" wrote:

> On Jul 17, 4:28 pm, Neufusion  wrote:
> > 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:
> > Unkown
> 
> Fixed it....
> Apparently playing with a SQL 2008 demo in the past caused some DLL
> hell.
> 
> SOLUTION:
> http://forums.msdn.microsoft.com/es-ES/Offtopic/thread/70a5cb26-6b20-43a0-8cef-a0c5716a3e1c/
> 
> Install the following from Microsoft SQL Server 2008 Feature Pack RC0,
> June 2008 -
> 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=089A9DAD-E2DF-43E9-9CD8-C06320520B40&displaylang=en
>

date: Tue, 12 Aug 2008 13:30:03 -0700   author:   hellsender

Re: VS 2008 Team - Database not supported / Can't load file or ass   

Thank you! This worked perfectly!  But the new download link is:

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

date: Thu, 25 Sep 2008 12:50:05 -0700   author:   Ben

Re: VS 2008 Team - Database not supported / Can't load file or ass   

Thank you all...

date: Tue, 30 Sep 2008 03:55:01 -0700   author:   Durana

Re: VS 2008 Team - Database not supported / Can't load file or ass   

Really thanks so mutch!!

"Durana" wrote:

> Thank you all...

date: Wed, 15 Oct 2008 09:16:00 -0700   author:   Cleber Moraes

Re: VS 2008 Team - Database not supported / Can't load file or ass   

Great work Neufusion - thank you!

date: Thu, 16 Oct 2008 07:24:01 -0700   author:   Napoleon

Re: VS 2008 Team - Database not supported / Can't load file or ass   

I have the same problem,  I uninstalled it SQL2008, and install again 
SQL2005, now not achievement to add the connection from VS2008, I did what 
mention and not achievement to connect me.  

Thanks by you help
Elmer Rodriguez
FROM El Salvador

"Neufusion" wrote:

> On Jul 17, 4:28 pm, Neufusion  wrote:
> > 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:
> > Unkown
> 
> Fixed it....
> Apparently playing with a SQL 2008 demo in the past caused some DLL
> hell.
> 
> SOLUTION:
> http://forums.msdn.microsoft.com/es-ES/Offtopic/thread/70a5cb26-6b20-43a0-8cef-a0c5716a3e1c/
> 
> Install the following from Microsoft SQL Server 2008 Feature Pack RC0,
> June 2008 -
> 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=089A9DAD-E2DF-43E9-9CD8-C06320520B40&displaylang=en
>

date: Tue, 21 Oct 2008 10:21:01 -0700   author:   Elmer Rodriguez Elmer