Missing ssrs and ssms client tools after install w/ config

  • I'm trying to do a sql server 2014 enterprise install using a config that i generated from an install on another server. This install will be the passive node. Regardless, after the install ran i can see that the ssrs, ssis, agent, sql engine services are indeed running. However, none of the client tools are installed. I'm not seeing the ssrs client nor SSMS. I checked and the SSMS binaries are not in the C:\Program Files\Microsoft SQL Server\120\Tools\Binn directory as i suspected. Anyone have any ideas how i can find out why these tools were not installed.

    Below is from the config
    ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality Services (DQS) server. The Tools feature will install Management Tools, Books online components, SQL Server Data Tools, and other shared components.

    FEATURES=SQLENGINE,REPLICATION,FULLTEXT,RS,CONN,IS,BC,BOL,SSMS,ADV_SSMS

  • sorry, i was looking in the wrong folder. It's in C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio

  • Snargables - Wednesday, March 15, 2017 8:27 AM

    sorry, i was looking in the wrong folder. It's in C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio

    Yes, SSMS is only available in 32 bit so will always be installed in Program Files (x86), where as SQL Server 2014 or prior can be 32 or 64 bit. SQL Server 2016 is 64 bit only. Thus if you install a 64 version, it will go in Program Files.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply