install SQL Server 2008 Client tools

  • Question:

    We are rolling out SQL Server 2008 R2 and I'm wondering if there is a way to install just the SQL Server 2008 R2 Management Studio without having access to full SQL Server 2008 R2 Standard Edition install?

    Is there seperate media for just the Mangement Studio???

  • Not on disk, but you can download sqlexpress with advanced tools and only instal ssms.

    http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=3743

    Jared
    CE - Microsoft

  • You could write an installation script for this, assuming the client has network access to a copy of the media something like (below) would install only management studio;

    \\yourserver\share\folderwithmedia\setup.exe /Action="Install" /IACCEPTSQLSERVERLICENSETERMS /ERRORREPORTING=0 /FEATURES=SSMS /INDICATEPROGRESS /SQMREPORTING=0 /Q


    -Ken

  • Jared:

    Does this version you mention come with the Execute Package Utility? If not, which FREE version of SQL Server can I download by which I can get the utility?

    Thanks!

  • mculley (12/3/2013)


    Jared:

    Does this version you mention come with the Execute Package Utility? If not, which FREE version of SQL Server can I download by which I can get the utility?

    Thanks!

    This is installed as part of SQL Server Integration Services feature. Not sure if express comes with it, but I think it does.

    Jared
    CE - Microsoft

  • Why not just follow these instructions with your normal installation media?

    http://www.mssqltips.com/sqlservertip/1807/sql-server-2008-client-tools-installation/

Viewing 6 posts - 1 through 5 (of 5 total)

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