Link to home
Start Free TrialLog in
Avatar of nummagumma2
nummagumma2Flag for United States of America

asked on

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.
Avatar of Aneesh
Aneesh
Flag of Canada image

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..
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.
Avatar of nummagumma2

ASKER

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.
just run the sql server setup and only choose the managment tools to instal.. You can install them standlone without database installation..
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.
tigin44, he is trying to user-proof (dummy-proof) the install process here.
dbaduck in on the right track.
dbaduck - CGLuttrell is dead on - I want to dummy-proof it. =)

Do you have an unattended mode script that could be used for this?
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.
dbaduck, did you forget the article reference?
ASKER CERTIFIED SOLUTION
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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