?
Solved

Install SQL 2008 tools only

Posted on 2010-01-06
12
Medium Priority
?
3,419 Views
Last Modified: 2012-06-27
Is there a super-secret .msi or .exe with SQL 2008 that lets you install only the tools?  The Express tools will not work for my purposes.   Ultimately I want to publish this in AD the way you can many .msi files.
0
Comment
Question by:nummagumma2
  • 4
  • 3
  • 2
  • +2
12 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 26194940
0
 
LVL 26

Expert Comment

by:tigin44
ID: 26194994
you may use the sql management studio express as proposed above post. By the way you may also install the Management Studio tools by using the sql server setup edition different then the express..
0
 
LVL 25

Expert Comment

by:DBAduck - Ben Miller
ID: 26195200
In the Tools directory there is an MSI or .EXE that you can use the setup just the tools.  The SQL Server stuff is in the Server directory of the media for the install.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 1

Author Comment

by:nummagumma2
ID: 26195423
aneeshattingal and tigin44 - the express versions will not work for my purposes.   I do not what to use the full installer as it permits the person installing it to install SQL.  I want them to have only the tools.

dbaduck - there is a sql_tools.msi in \x64\Setup, and \x86\setup.  This generates msiexec errors when you try to run it directly..   The sql_tools_loc.msi in \xYY\setup\1033 also does not install.
0
 
LVL 26

Expert Comment

by:tigin44
ID: 26195449
just run the sql server setup and only choose the managment tools to instal.. You can install them standlone without database installation..
0
 
LVL 25

Expert Comment

by:DBAduck - Ben Miller
ID: 26195618
I do not know of an .msi that you can run to install the tools, but if you run Setup.exe in the \xYY\tools\setup\ directory, you can install just the tools without using the installer of the server.  We have just run it in unattended mode.
0
 
LVL 27

Expert Comment

by:Chris Luttrell
ID: 26195640
tigin44, he is trying to user-proof (dummy-proof) the install process here.
dbaduck in on the right track.
0
 
LVL 1

Author Comment

by:nummagumma2
ID: 26196184
dbaduck - CGLuttrell is dead on - I want to dummy-proof it. =)

Do you have an unattended mode script that could be used for this?
0
 
LVL 25

Expert Comment

by:DBAduck - Ben Miller
ID: 26196965
Here is the article you want to do exactly what you want.  Now pay attention to the /qn for no dialogs or /qb for showing the dialogs during the unattended.
0
 
LVL 27

Expert Comment

by:Chris Luttrell
ID: 26197026
dbaduck, did you forget the article reference?
0
 
LVL 25

Accepted Solution

by:
DBAduck - Ben Miller earned 2000 total points
ID: 26197053
0
 
LVL 1

Author Closing Comment

by:nummagumma2
ID: 31673737
Thanks for pointing me in the right direction.  It looks like the installer was changed (again) for SQL 2008 and this method doesn't work exactly.  However, setup /? shows the correct syntax:

start /wait \\path\folder\setup.exe /QUIETSIMPLE /action=install /features=Tools
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question