Install SQL 2008 tools only

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.
LVL 1
nummagumma2Asked:
Who is Participating?
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
0
 
tigin44Commented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
DBAduck - Ben MillerPrincipal ConsultantCommented:
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
 
nummagumma2Author Commented:
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
 
tigin44Commented:
just run the sql server setup and only choose the managment tools to instal.. You can install them standlone without database installation..
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
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
 
Chris LuttrellSenior Database ArchitectCommented:
tigin44, he is trying to user-proof (dummy-proof) the install process here.
dbaduck in on the right track.
0
 
nummagumma2Author Commented:
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
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
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
 
Chris LuttrellSenior Database ArchitectCommented:
dbaduck, did you forget the article reference?
0
 
nummagumma2Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.