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

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

  • Comments 1

 

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 http://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 http://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

 

 

 

 

Leave a Comment
  • Please add 6 and 7 and type the answer here:
  • Post
  • nice blog and information about Installing Client tools for SQL 2008 doesn’t populate the SMO in the SQL Assemblies folder and <a href="www.datasparc.com/ms-sql-server-client-tools.html"> microsoft sql server client tools </a>.

Page 1 of 1 (1 items)