December 22, 2013 at 12:27 pm
How can we do unattended installation. What is this benefit? I saw one link in that they remember the configuration file path and later they created .bat file. How can we create bat file and what is the use of bat file. Is any change for different versions from sql 2005-2012.
December 22, 2013 at 11:25 pm
Hope this helps..!
http://mssqlfun.com/2013/01/29/sql-server-silent-unattended-installation-using-configuration-file/
Regards,
Kumar
December 23, 2013 at 7:17 pm
Hi,
I tried to unattended installation as in that link. I did up to 5. When I try change the parameters in the configuration file.ini it is not saving. So I take the original configuration file copy on the desktop and make the changes for parameters. My software is on the desk top and when I go to the setup.exe it is opening the E-drive so I create .bat file with E:/setup.exe\configurationfile.ini=my configurationfile on the desktop
I run the .bat in cmd
but I am getting error messages. I am unable to provide the error msg.
Some times it showing the configuration file is not available.
Some times the location is error.
One time it showed me check the detailed text
December 30, 2013 at 3:56 am
There are a few tools that can help with unattended installs.
You have the basic config file edit that comes with SQL Server, and you can wrap this up in a your own script if you want to automate things further.
SQLSpade http://sqlspade.codeplex.com/ goes a bit further, and makes it easier to specify options for different SQL installs. It also has a GUI and can do some post-install configuration.
SQL FineBuildhttp://sqlserverfinebuild.codeplex.com/ does a lot more but has no GUI. SQL FineBuild covers the preparation of the server for SQL, the SQL install, installation of community tools, and post-install configuration, for both unclustered and clustered SQL installs.
Whichever tool you use, it is important to read the documentation to make sure you get the features installed that you need.
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
December 30, 2013 at 4:06 am
The main benefit of doing an unattended installation is you can guarantee repeatability.
It is too easy with a manual install to forget to select a given option or put a folder on a different drive. Unattended installation allows you to show to management and auditors that you have a consistent way to deploy SQL Server. An unattended SQL installation can also take up less of your own time - our DBAs typically run multiple installs at the same time because everything is scripted.
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
December 30, 2013 at 5:41 am
EdVassie (12/30/2013)
The main benefit of doing an unattended installation is you can guarantee repeatability.It is too easy with a manual install to forget to select a given option or put a folder on a different drive.
Provided someone doesn't meddle with the config file between deployments;-)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply