August 16, 2010 at 8:19 am
Hi, in order to keep my legwork to a minimum I am trying to give a number of developers the ability to install SQL Server client tools by themselves from a share on a server. I don't want then to be able to install a complete sql server 2008 db server on their workstation. Is there any way of doing this? I know with SQL 2005 I was able to separately run the SQL client tools msi and install manually. I have tried the same with SQL 2008 and this does not work.
Thanks in advance.
August 16, 2010 at 9:52 am
I would suggest downloading the SQL Server 2008 R2 Management Studio Express from http://www.microsoft.com/downloads/details.aspx?familyid=56AD557C-03E6-4369-9C1D-E81B33D8026B&displaylang=en.
This is basically the Client tools in a separate package. The only catch is that BIDS may be more limited than if they installed client tools from the full distribution DVD. But I can't think of any limitations right off.
August 16, 2010 at 10:26 am
The best option would be to try the command line install. It would allow you to specify what can be installed, down to specific features.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
August 19, 2010 at 8:49 am
Thanks MeltonDBA. This worked a treat:
Setup.exe /q /Action=Install /Features=ADV_SSMS
August 19, 2010 at 9:01 am
Command line works best when possible.
SSMS Express is missing certain features (replication monitor and some other enterprise-level stuff) but works for 99.9% of the things most devs need it for, which is just creating/viewing/testing/updating code. I've never once had someone come back to me after setting them up with SSMS express and tell me they needed a feature on the full version.
April 22, 2015 at 11:08 am
For those that need SSIS, is there a limit on Client Tools installs from a purchase of SQL 2012? This thread is the only thing of promise that came up when I tried researching.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy