Installing Client tools for SQL 2008 doesn’t populate the SMO in the SQL Assemblies folder

  • Article

Recently I encountered this issue. Customer was trying to install SMO by using the following switch in the setup command line for SQL 2008:

/FEATURES=SNAC_SDK

However, the installation didn’t cache the SMO dll’s in the c:\program files\Microsoft SQL Server\100\SDK\Assemblies folder – as suggested in the below article:

Installing SMO https://msdn.microsoft.com/en-us/library/ms162189.aspx

However, these dlls are cached in GAC (Global Cache Assembly) c:\windows\assembly.

He wanted to know how to cache these assemblies in to the c:\program files\Microsoft SQL Server\100\SDK\Assemblies folder

I tried reproducing this issue. Installed the below features:

· Client Tools Connectivity

· Client Tools Backward Compatibility

· Client Tools SDK

· SQL Client Connectivity SDK

· BIDS

Still the Assemblies folder was not getting created under c:\program files\Microsoft SQL Server\100\SDK\ folder.

Later, installing the SMO from the Management Feature pack helped populate the assembly cache.

The Feature pack is available at https://www.microsoft.com/downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en

Venkatraghavan

SE, SQL support

Reviewed by:

Nickson Dicson & Shamik Ghosh

TL, SQL support