SSMS Client Tools

  • Is there a client tool only installer that is available out there? I tried to use the SSMS Express but that wouldn't let me view the databases. I would like to avoid using the SQL Server Standard Edition to install client tools since the group that usually does the installation might end up installing the database engine as well.

    Any suggestions?

    TIA

  • No. And I don't understand your trepidation about using SS SE. If you want to make sure someone else only performs the client tool installation, put the following command in a bat file and make them use the bat fiel for installation. This installs the Client tools only.

    Start /wait <CD or DVD Drive>\servers\setup.exe /qb INSTANCENAME=<InstanceName> ADDLOCAL=SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SQL_WarehouseDevWorkbench,SQLXML,Tools_Legacy,SQL_Documentation,SQL_BooksOnline PIDKEY=<pidkey value with no "-"> SAPWD=<StrongPassword>

    For more info: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm#installationscripts


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • No. And I don't understand your trepidation about using SS SE. If you want to make sure someone else only performs the client tool installation, put the following command in a bat file and make them use the bat fiel for installation. This installs the Client tools only.

    Start /wait <CD or DVD Drive>\servers\setup.exe /qb INSTANCENAME=<InstanceName> ADDLOCAL=SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SQL_WarehouseDevWorkbench,SQLXML,Tools_Legacy,SQL_Documentation,SQL_BooksOnline PIDKEY=<pidkey value with no "-"> SAPWD=<StrongPassword>

    For more info: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm#installationscripts


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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