Working With Databases In Visual Studio Without SQL Server Installed

When you get the following error after trying to connect to a database in Visual Studio 2010.

—————————
Microsoft Visual Studio
—————————
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.
—————————
Simply download and install the following components.

Microsoft SQL Server System CLR Types – http://go.microsoft.com/fwlink/?LinkId=123721&clcid=0x409

Microsoft SQL Server 2008 Management Objects – http://go.microsoft.com/fwlink/?LinkId=123708&clcid=0x409

Microsoft SQL Server 2008 Native Client – http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409

I run into this quite a bit when working on client provided developer workstations and they don’t find the need in installing a local SQL Server or the management objects.

The other alternative is to simply download and install SQL Server Management Studio.