Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

unattended installation of sql sever 2008 Expand / Collapse
Author
Message
Posted Tuesday, January 27, 2009 3:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:27 AM
Points: 154, Visits: 437
Hi all,

I have to install MS SQL Server 2008 on about 150 remote servers. Since doing this is a tedious task, I was wondering if there is a template script or a document on unattended installation of MS SQL Server 2008.


Thanks a lot

Niyala
Post #644016
Posted Tuesday, July 28, 2009 5:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 25, 2011 5:55 PM
Points: 24, Visits: 7
Yes do a single installation with all the settings as u want them then take the ini file that it references and use a script the contains the following command line

setup.exe /configurationfile="path to ini file referenced above"

run once to test instatalltion if it is correct modify the ini file to allow silent install

; Setup will display progress only without any user interaction.
QUIETSIMPLE="True"


This has worked for me for a single instance although getting multiple instances is proving a bit more difficult

alternating run setup /? and review the guidance for a command line install everything in the configuration file can be set via the command line


Post #761189
Posted Tuesday, July 28, 2009 9:43 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 7, 2014 8:23 AM
Points: 318, Visits: 351
As well you can use powershell to cycle through the servers and kick off the installs.
It's quite a lovely sight to see really.



Watch my free SQL Server Tutorials at:
http://MidnightDBA.ITBookworm.com

Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://www.infoworld.com/blogs/sean-mccown
DBA Rant – http://dbarant.blogspot.com
Post #761248
Posted Wednesday, July 29, 2009 5:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 2,879, Visits: 3,228
Youi may find SQL FineBuild helpful. You can gt this either by following the link below or direct from CodePlex.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #761414
Posted Wednesday, July 29, 2009 6:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:27 AM
Points: 154, Visits: 437
Hi,

in fact I implemented long ago exactly as are suggesting. It works very well. I even gave the routines to a technician and he is running all the installation.

Thanks indeed for your reply.

Niyala
Post #761424
Posted Wednesday, July 29, 2009 6:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:27 AM
Points: 154, Visits: 437
Hi,

I soloved this problems long ago. However, trying with PowerShell must a good idea. Do you such examples that you previously applied?

Thanks indeed for your hints.

Regards

Niyala
Post #761425
Posted Tuesday, April 2, 2013 7:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 29, 2014 4:31 AM
Points: 1, Visits: 29
If I want to do unattended installation for SQL Server 2008 using configuration.ini with batch

Setup.exe /ConfigurationFile=MyConfigurationFile.INI

Certain parameters I want to assign on command prompt. Is it possible.

If I want to do interactive installation What modification I should do on batch script
Post #1437877
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse