June 20, 2011 at 11:20 pm
Hi Folks,
Is it possible to install sql server 2005 on 1000 different machines at-a-time?
If it is,
kindly help me on this.
TIA..
June 21, 2011 at 1:30 am
Yes , look up silent install
http://blog.sqlauthority.com/2007/04/10/sql-server-2005-silent-installation-unattended-installation/
You will need to manually or automate the actual invocation of the installation process. Usually using an enterprise automation tool.
June 21, 2011 at 3:01 am
Hi Jayanth_kurup thanks for your warm response,
Actually i didn't understood what you said, Can u please let me know the step by step process.
That should be very helpful to me..
June 21, 2011 at 3:22 am
SQL Server can be setup in two ways , the first one is by clicking the install screens and specifying the required setup details. The second option is to perform silent installations , this uses a pre configured file to pass input to the installer once the setup is started.
the below link shows each step in more detail, I would expect you to take it from here or you can pay me to get it done for you 😀
http://www.databasejournal.com/features/mssql/article.php/3611426
June 21, 2011 at 4:53 am
Microsoft books online shows exactly how to configure your system for performing stand alone installs through the command line. You can then do this from a batch file or, better still, look up how to do it through PowerShell.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 4, 2011 at 6:42 am
You may be interested in SQL FineBuild. This allows you to do an install and best-practice configuration of SQL Server in a single click.
If you are planning to install SQL on 1000 servers, you may want to think about what roles these servers will do. Will they all need to have the same configuration, or will some need a different configuration according to the role they perform. Either way, FineBuild can help you put standardised builds on as amay servers as you want.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply