/build/static/layout/Breadcrumb_cap_w.png

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login
Views: 7.6k  |  Created: 10/10/2007

Average Rating: 0
SQL Server has 53 inventory records, 39 Questions, 6 Blogs and 18 links. Please help add to this by sharing more!

Deployment Tips (5)

Most Common Setup Type
Not Determined
Average Package Difficulty Rating
Rated 0 / 5 (Not Rated) based on 0 ratings
Most Commonly Reported Deployment Method
Not Determined

Deployment Tip Summary

19
Command Line
Here is an example of a silent installation of Management Tools - Basic and Management Tools - Complete:

setup.exe /QS /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /FEATURES=SSMS,ADV_SSMS /HIDECONSOLE
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
5
Note
Another way of customizing the installation is by creating an INI file. This is done by running the installation steps untill you have to click the install button.
The look into the folder "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log" for "DefaultInstallation.ini" file.
You can copy this file next to "setup.exe" file and run it using the following commnand line:
<path_to_setup.exe> /ConfigurationFile=<path_to_install.ini>
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
4
Note
There is a bug in the installation that has been around since SQL 2005. The original installation sets the following key:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\TlbAutoRepair\mscorlib.tlb]
"TlbPath"="%windir%\Microsoft.NET\Framework\%CLRVERSION%\mscorlib.tlb"

"%CLRVERSION%" can be misinterpreted during installation causing an error when trying to start Management Studio.
Changing "%CLRVERSION%" to "v2.0.50727" fixes the problem:

This error can easily be fixed by editing x86\Setup\sql_ssms.msi

More info here: http://support.microsoft.com/kb/918685
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
0
Note
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
-3
Command Line
To install Management Studio full tools silently

setup.exe /Q /ACTION=Install /FEATURES=Tools

To unistall

setup.exe /Q /ACTION=Uninstall /FEATURES=Tools
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows

Questions & Answers (39)

Questions & Answers related to Microsoft SQL Server

4
ANSWERS
2
ANSWERS
0
ANSWERS
1
ANSWERS
2
ANSWERS
0
ANSWERS
0
ANSWERS
6
ANSWERED
1
ANSWERS
1
ANSWERS
1
ANSWERS
3
ANSWERED
9
ANSWERED
1
ANSWERS
1
ANSWERS
11
ANSWERS
2
ANSWERS

Blogs (6)

Blog posts related to Microsoft SQL Server

Reviews (0)

Reviews related to Microsoft SQL Server

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ