/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: 9.4k  |  Created: 10/10/2007

Average Rating: 0
SQL Server has 53 inventory records, 45 Questions, 6 Blogs and 17 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
  • Arctos
  • 02/02/2011  
  • Show Comments   ( 0 )

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
  • andrei.m
  • 02/17/2011  
  • Show Comments   ( 0 )

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
  • Arctos
  • 02/02/2011  
  • Show Comments   ( 0 )

0
Note

How to Install SQL Server 2012 Using a Configuration File:

http://msdn.microsoft.com/en-us/library/dd239405.aspx

Example:

http://www.codeproject.com/Articles/113480/SQL-Server-2008-R2-Unattended-Silent-Install
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
  • shag
  • 12/11/2012  
  • Show Comments   ( 0 )

-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 (45)

Questions & Answers related to Microsoft SQL Server

0
ANSWERS
Is it possible to create an email alert for a SQL Security Account that has Password Expiration enabled and to send that alert prior to actual password expiration?
By: ronni3 1 year ago 0 views
3
ANSWERS
how can we give a Label modes of transport by speed in sql?
By: lovedeep 2 years ago 0 views
Ragnorrak answered 2 years ago
0
ANSWERS
MS-SQL Server 2014 adding a new instance: asks for installation media
By: zamank 2 years ago 0 views
4
ANSWERS
SQL Server 2012 Service Pack 4 CU (KB4583465) Won't Show
By: lama01 3 years ago 0 views
vigasi answered 2 years ago
2
ANSWERS
A question about sql syntax
By: Flemtone 3 years ago 198 views
chucksteel answered 3 years ago
1
ANSWERS
I want to display only device with an arrow icon. anyone can help me this SQL query. Thanks
By: Daniel Thenu 3 years ago 262 views
airwolf answered 3 years ago
1
ANSWERS
Anybody have this error EFI PXE Boot K200 _unseccessful.hell (Unsupported Option)0) PXE-E23: Client recieved TFTP error from server?
By: agahlbeck 4 years ago 1.7k views
Channeler commented 4 years ago
4
ANSWERS
SQL Server Management Studio 2017 - Silent uninstall failed (requires restart)
By: FrustrationFruit 5 years ago 7.6k views
jguthrie answered 5 years ago
2
ANSWERS
I need to fix my mistake in the database.
By: JessaMcdowell 5 years ago 621 views
JasonEgg commented 5 years ago
0
ANSWERS
Kace reporting SQL query adjustment
By: lbuckhout 5 years ago 1k views
Druis commented 5 years ago
1
ANSWERS
I don't have enough experience with databases
By: reesewilkerson 5 years ago 634 views
ohiosoundguy commented 5 years ago
2
ANSWERS
Kace Service Desk SQL Report Question
By: Jenafyre 6 years ago 1.1k views
Jenafyre commented 6 years ago
0
ANSWERS
Report for full SQL Server installs
By: carlson03049 6 years ago 891 views
0
ANSWERS
How to Write a SQL Query for a Report?
By: RedHoodJT 7 years ago 1.2k views
chucksteel commented 7 years ago
6
ANSWERED
database doesn’t open via sql server
By: Billywon095 7 years ago 1k views
1
ANSWERS
Remote uninstall methods for SSIS
By: Emarrow 7 years ago 927 views
anonymous_9363 answered 7 years ago
1
ANSWERS
Damage of the SQL database
By: GerardLefebvre92 8 years ago 1.5k views
1
ANSWERS
What is the silent uninstallation command to uninstall Microsoft_SQL Server Client Tools_2014?
By: Rachana 8 years ago 4.8k views
SMal.tmcc answered 8 years ago
3
ANSWERED
SQL Server 2000 Cannot Attach Database, Problem with LDF File
By: mareliwalberg 8 years ago 2.3k views
haaniomar answered 8 years ago
18
ANSWERED
Repair Corrupt Database?
By: brenovieira 8 years ago 2.7k views
Danishtj answered 1 year ago
More Questions

Blogs (6)

Blog posts related to Microsoft SQL Server

blog
GoalKicker: Free Programming Books
By: jonniipalos 4 years ago 8.5k views
blog
Spectacular Microsoft fail - SQL Server installation
By: anonymous_9363 5 years ago 3.9k views
blog
Security Hardening of Windows by Reducing Privileged Access
By: derekmelber 7 years ago 2.9k views
blog
Some more SQL Scripts.
By: mikesharp1 9 years ago 3.1k views
blog
Flyspeed SQL Scripts
By: mikesharp1 9 years ago 3.4k views
blog
System Center Management Suite Microsoft SQL Licenses
By: dedenker 9 years ago 9.7k views

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