locked
SQL Server 2016 RC3 Feature Pack RRS feed

  • Question

  • Hello,

    Where can I find the Shared Managed Objects MSI for SQL Server 2016 RC3 ?

    I have an application that requires SMO and built against SMO 2016 dll's and at runtime i got the following error:

    Received the following from the MS SQL server: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

    I see that SQL 2016 feature pack https://www.microsoft.com/en-us/download/details.aspx?id=51939 does not include SMO installation package. This is in comparison with 2008 R2 https://www.microsoft.com/en-us/download/details.aspx?id=16978

    Monday, May 9, 2016 11:14 AM

Answers

  • Hi tionescu,

    There is no SMO msi in the RC3 release of SQL Server feature pack 2016, regarding to this issue, I would recommend you submit a feedback to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback.

    In addition, as described in this article, if you want to develop an application that uses SQL Server Management Objects (SMO), you should select the Client Tools SDK when you install SQL Server.

    Moreover, based on this article, Client Tools Backward Compatibility includes SQL Distributed Management Objects (SQL-DMO) and
    Decision Support Objects (DSO).

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support


    Tuesday, May 10, 2016 7:14 AM

All replies

  • Hello,

    Please run SQL Server setup program, on the “Feature Selection” page select the option named “Client Tools SDK”. SMO is installed as part of that SDK.

    Hope this helps.



    Regards,



    Alberto Morillo
    SQLCoffee.com

    Monday, May 9, 2016 11:40 AM
  • Thanks for quick answer. If the server level is 2014 and not 2016 should i install "Client Tools Backwards Compatibility" ? It looks so because i just tried and it works. Please confirm.
    Monday, May 9, 2016 12:00 PM
  • Hello,

    To my knowledge there is just two ways to install SMO. One way to install it is installing Client Tools SDK as mentioned before. The other option to install SMO is by downloading "Shared Management Objects .msi" from SQL Server Feature Pack.

    You should be able to find SMO assemblies on the following path:

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

    Hope this helps.



    Regards,



    Alberto Morillo
    SQLCoffee.com

    Monday, May 9, 2016 12:19 PM
  • Hi Alberto,

    1) It looks that SMO is installed if you only install "Client Tools Backward Compatibility" feature.

    I assume that you are also right that "Client Tools SDK" has to be installed. But as i am working on SQL 2014 i assumed it should backward compatibility feature instead.

    2) Can you find the SMO MSI for SQL 2016 at https://www.microsoft.com/en-us/download/details.aspx?id=51939 ?

    Please clarify.

    Monday, May 9, 2016 12:44 PM
  • Hi tionescu,

    There is no SMO msi in the RC3 release of SQL Server feature pack 2016, regarding to this issue, I would recommend you submit a feedback to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback.

    In addition, as described in this article, if you want to develop an application that uses SQL Server Management Objects (SMO), you should select the Client Tools SDK when you install SQL Server.

    Moreover, based on this article, Client Tools Backward Compatibility includes SQL Distributed Management Objects (SQL-DMO) and
    Decision Support Objects (DSO).

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support


    Tuesday, May 10, 2016 7:14 AM
  • Thanks Lydia for links and suggestion. I just opened a bug feedback. Hope to get the location for the SMO redistributable installation package. :-)
    Tuesday, May 10, 2016 12:08 PM