I can't add Microsoft.SqlServer.Management.Common to my ASP.NET MVC Application

I am trying to add a reference to the above assembly but it does not appear in my ASP.NET MVC .NET开发者_如何学Python 4 (Not client) applications Assembly list. Does anyone know how to reference this Assembly?

The Microsoft.SqlServer.Management.Common namespace resides in the Microsoft.SqlServer.ConnectionInfo.dll assembly.

Microsoft.SqlServer.Management.Common Namespace (MSDN)

Assuming the default installation folders you can find the Microsoft.SqlServer.ConnectionInfo.dll assembly in:

C:\Program Files\Microsoft SQL Server\XXXX\SDK\Assemblies

Where XXXX represents the version of SQL Server you're running:

80  -> SQL Server 2005
90  -> SQL Server 2008
100 -> SQL Server 2008R2

If you're running SQL Server 32bit on x64 then instead of c:\Program Files use c:\Program Files (x86).