|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: 2 days ago @ 5:26 AM
Points: 131,
Visits: 311
|
|
Hi List,
I have been trying to install MS SQL Sever 2008 using a script, that means, I would like to do quiet installation unattended. I edited the configuration file that is created during the installation process of MS SQL Server 2008, but I am not sure if I am doing the right thing. Has anyone got experience with scripted installation? I was wondering if anyone has such a script which has been tested.
I would be very grateful for your help
Niyala
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 12:35 PM
Points: 1,715,
Visits: 5,099
|
|
Here's and example that just installs the client tools.
The whole syntax is in BOL, this should help you get started though.
;SQLSERVER2008 Configuration File
[SQLSERVER2008]
; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.
ACTION="Install"
; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, and Tools. The SQL feature will install the database engine, replication, and full-text. The Tools feature will install Management Tools, Books online, Business Intelligence Development Studio, and other shared components.
FEATURES=BIDS,CONN,BC,BOL,SSMS,ADV_SSMS
; Displays the command line parameters usage
HELP="False"
; Specifies that the detailed Setup log should be piped to the console.
INDICATEPROGRESS="False"
; Setup will not display any user interface.
QUIET="False"
; Setup will display progress only without any user interaction.
QUIETSIMPLE="False"
; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system.
X86="False"
; Specifies the path to the installation media folder where setup.exe is located.
;MEDIASOURCE="D:\SQL2008\"
MEDIASOURCE=".\install"
; Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to enable and 0 or False to disable this feature.
ERRORREPORTING="False"
; Specify the root installation directory for native shared components.
INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"
; Specify the installation directory.
INSTANCEDIR="C:\Program Files\Microsoft SQL Server"
; Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to enable and 0 or False to disable this feature.
SQMREPORTING="False"
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 9:31 AM
Points: 1,911,
Visits: 1,502
|
|
Take a look at FineBuild for SQL Server 2008 http://www.codeplex.com/SQLServerFineBuild/Release/ProjectReleases.aspx?ReleaseId=18003
SQL Server FineBuild gives 1-click installation and best-practice configuration of SQL Server. It gives everyone a rock-solid foundation for exploiting SQL, regardless of their skill level.
The current version for SQL 2008 is still in beta but it is stable. There are a few things I still want to add to it (MDW setup, RS admin account setup) before I declare it finished, but what is published is definitely worth using.
Update 20 June 2009 FineBuild for SQL Server 2008 is now fuly released on Codeplex.
Author: SQL Server FineBuild 1-click install and configuration of SQL Server 2005 and 2008.
1 October 2009: now over 7,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Fun: You can lead a user to data, but you can't make them think (Anon).
|
|
|
|
