nummagumma2
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.
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.
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.
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 in on the right track.
ASKER
dbaduck - CGLuttrell is dead on - I want to dummy-proof it. =)
Do you have an unattended mode script that could be used for this?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
start /wait \\path\folder\setup.exe /QUIETSIMPLE /action=install /features=Tools
http://www.microsoft.com/downloads/details.aspx?familyid=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en