Views: 3.9k  |  Created: 10/10/2007

Average Rating: 0
SQL Server has 53 inventory records, 30 Questions, 4 Blogs and 19 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
or cancel
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
Please log in to comment
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
Please log in to comment
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
Please log in to comment
0
Note
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
-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
Please log in to comment

Questions & Answers (30)

Questions & Answers related to Microsoft SQL Server

22
ANSWERS
2
ANSWERED
4
ANSWERS
3
ANSWERS
1
ANSWERS
4
ANSWERED
1
ANSWERS
2
ANSWERS
1
ANSWERS
1
ANSWERED
1
ANSWERS
2
ANSWERED
1
ANSWERS
1
ANSWERS
2
ANSWERS

Blogs (4)

Blog posts related to Microsoft SQL Server

Reviews (0)

Reviews related to Microsoft SQL Server