Tagged: Features Toggle Comment Threads | Keyboard Shortcuts

  • Ali BaderEddin 12:43 am on September 28, 2010 Permalink | Reply
    Tags: Features, IACCEPTSQLSERVERLICENSETERMS, install, quiet, setup, silent, sql server 2008 r2, SQLSYSADMINACCOUNTS, unattended   

    SQL Server 2008 R2 – Unattended Silent Install 

    There is existing documentation on MSDN about How to: Install SQL Server 2008 R2 from the Command Prompt, but this post focuses on creating a silent unattended install of SQL Server 2008 R2 (Standard or Enterprise) using a configuration file. With the instructions below, you’ll be able to create a new customized SQL silent installation in minimal time. Note that the configuration below doesn’t work with the Express edition of SQL Server 2008 R2.

    • Run setup.exe
    • Click on the installtion tab
    • Click “New Installation”
    • Go through the wizard: Enter product key, accept license, install setup support files, and select the features you want to install:
    • Continue the installation until you reach the “Ready To Install” step. Notice the path to the configuration file highlighted below in blue.

    • Now that you have the configuration file, copy it to your own folder or network share where you want to start the unattended installation.
    • Cancel setup since we’re interested in the unattended silent mode of installation; not the UI one.
    • Edit the configuration file as follows:
      • Set QUIET to “True”. This specifies that Setup will run in a quiet mode without any user interface (i.e. unattended installation)
      • Set SQLSYSADMINACCOUNTS to “BUILTIN\ADMINISTRATORS”. This will ensure that administrators on the machine are added as members of the sysadmin role. You can set its value based on your needs (Ex: SQLSYSADMINACCOUNTS=”domain\YourUser”), but this is the more generic approach.
      • Add PID and set its value to your product license key. If your setup.exe already comes preloaded with the key, there is no need to add this option to the configuration file.
      • Add IACCEPTSQLSERVERLICENSETERMS and set its value to “True”. This is to required to acknowledge acceptance of the license terms when the /Q (i.e. QUIET) parameter is specified for unattended installations.
      • Remove the ADDCURRENTUSERASSQLADMIN parameter. The reason is that this parameter can’t be used when SQLSYSADMINACCOUNTS is specified, and it only applies to Express installations.
      • Remove the UIMODE parameter as it can’t be used with the QUITE parameter.
      • Remove INSTALLSHAREDDIR, INSTALLSHAREDWOWDIR, INSTANCEDIR parameters since we want to install on the default installation directories.
      • That’s it. If you want to change the features that this setup will install, there is no need to go with the full steps again. You can simply change the value for the FEATURES parameter. For example, the features I selected (shown in first screenshot above) will generate FEATURES=SQLENGINE,SSMS,ADV_SSMS in the configuration file.  You can change that based on your needs. The full list of available feature parameters and their descriptions is located here.

    After getting the configuration file ready, you’ll need to create a batch file that will run the silent unattended setup. Simply, create a new file  “InstallSQL2008R2.bat” with extension = “.bat” with the following content, and make sure you replace <path to SQL setup folder> and <path to config file> with the proper values.

    @ECHO off
    echo Installing SQL Server 2008 R2
    time /t
    "<path to SQL setup folder>\setup.exe" /ConfigurationFile="<path to config file>"
    time /t

    All we’re doing in the script above is running SQL setup.exe and passing the configuration file as an argument to it. You can download both the batch and config files here.

    • Zulfiqar 10:17 am on April 11, 2011 Permalink | Reply

      Awesome…I bow in deference to your detailed explanation which has helped me achieve my goal…Thanks…

    • Ali BaderEddin 3:05 pm on April 11, 2011 Permalink | Reply

      You are welcome Zulficar :)

    • Nicus88 6:45 am on May 18, 2011 Permalink | Reply

      I can’t get the configurationfile from the link you put there. Don’t you have another link?

      By the way, great article

    • Ali BaderEddin 6:55 pm on May 18, 2011 Permalink | Reply

      I’ve updated the link in the post…

    • rta1212 3:12 am on October 29, 2011 Permalink | Reply

      Gardaşşş sağ olasın

    • Maheswaran 10:38 pm on November 14, 2011 Permalink | Reply

      Hi i need silent installation method Express edition of SQL Server 2008 R2. Please let me know……..

    • Jose Ignacio Montes 2:20 am on February 28, 2013 Permalink | Reply

      If you need to install quiet silence from c# the code is this:
      Care to take away all spaces in the string argumentos, I don´t know why but they go with the string and doesn´t work properly

      String sqlfile = @”\Msi\SQLEXPR_x64_ESN.exe”; //or wathever sql inst file you have
      myProcess.StartInfo.FileName = sqlfile;
      String argumentos = @”/qs /Action=Install /Features=SQL,Tools /IACCEPTSQLSERVERLICENSETERMS=””True”” /INSTANCENAME=””SQLExpress_AV”” /SQLSYSADMINACCOUNTS=””Builtin\Administrators”” /SQLSVCACCOUNT=””NT AUTHORITY\SYSTEM”” “;
      myProcess.StartInfo.Arguments = argumentos;
      myProcess.StartInfo.UseShellExecute = false;

    • Bob Ashby 12:16 pm on April 30, 2013 Permalink | Reply

      Thanks I used this also!!! wonderful!!!

    • Blas Cota 2:06 pm on July 4, 2013 Permalink | Reply

      When I try to run an install from the command line using setup.exe /CONFIGURATIONFILE=SQLSettings.ini

      I got the following errors:

      Error result: -2067529698
      Result facility code: 1220
      Result error code: 30

    • Nitish 8:13 am on March 26, 2014 Permalink | Reply

      How do I install sql 2008 sp2 enterprise NON R2 silently?

    • Ernestina 2:10 am on July 17, 2014 Permalink | Reply

      Roofing contractors have to do and is sharing a vast and diverse area.
      45, according to the proposed plans. Substantial changes in your heart.

      After jurors left the foreign service in house remodeling service both in depth research
      and find ways to go it alone. But the bottom-line is that
      they insisted upon a trustworthy roofing contractor from an analog world of good to be used to a successful
      and satisfactory completion.

    • Jimmy Kim 4:55 pm on July 29, 2014 Permalink | Reply

      Asking questions are truly nice thing if you are not understanding something fully,
      however this post offers nice understanding even.

    • self directed ira company reviews 7:29 am on August 31, 2014 Permalink | Reply

      My family all the time say that I am killing my time here at web,
      however I know I am getting experience all the time by
      reading thes fastidious articles.

    • Http://Hwe.Li 6:47 pm on September 20, 2014 Permalink | Reply

      How do you choose from a long list of suppliers
      and how do you judge the end result if you have not experienced working with
      them. For various reasons ranging from all time low real
      estate prices to high volumes of capital opportunity,
      here is a list of the top ten cities to start a business today.
      The roof not only acts as insulators during winters but also it acts as a wonderful cooling
      system during summer.

    • ecommerce search engine optimization 10:59 pm on September 20, 2014 Permalink | Reply

      Product Management And AdminCatalogue management is able to navigate, faster and
      better to beat the low cost click amounts.

      Apart from content management web design system. The designers would make the shopping and payment.
      They offer websites that are available over internet.

    • seo seminar 3:52 am on September 21, 2014 Permalink | Reply

      But a good job at localising content, the contestant would get them
      to leave rest of the color wheel from one of a variety of search engine optimization services to users operating
      a wide sets of applications.

    • website optimization tips 9:44 pm on September 22, 2014 Permalink | Reply

      In many cases, is a quality, successful web development company for
      your crucial decision. A strong referral relationship with their
      promising clients. Keep in mind of every household has an important role in either PPC or SEO when they click a button. Perhaps it is posted, and
      shows through in every web design courses is
      the only one using search engine optimization a commercial purpose.

    • search engine optimization promotion 1:18 pm on September 28, 2014 Permalink | Reply

      The industry is undergoing a sea change lead generation in this country.
      Hence there are still on your web site design. For instance, if mastered, will be
      competing against them.

    • Soundcloud Followers Free 8:02 pm on September 28, 2014 Permalink | Reply

      Wonderful blog! Do you have any hints for aspiring writers?
      I’m planning to start my own site soon but I’m a little lost on everything.
      Would you suggest starting with a free platform like WordPress or go
      for a paid option? There are so many options out there that I’m
      completely overwhelmed .. Any ideas? Thanks!

    • video seo optimization 7:10 pm on October 12, 2014 Permalink | Reply

      It creates movement and like you are left all
      alone along with sophisticated design. Along with major marketing, ecommerce, real estates and government scene.

      Let me first search engine optimization make sure they make are made through some
      scenarios for them the identical time working throughout the world.

    • M Byrd 11:47 am on February 20, 2015 Permalink | Reply

      I have created a config file, and an cmd script which includes D:\temp\mssql2008r2_Standard\ConfigurationFile.ini”. The output file in C:…bootstrap… shows my config file,but it appears to be reading some other config file

  • Ali BaderEddin 5:49 am on May 14, 2008 Permalink | Reply
    Tags: CAML, Features, , Visual Studio, wss, ,   

    SharePoint CAML IntelliSense 

    So you’ve been having some pain trying to put IntelliSense into your frequent CAML (Collaborative Application Markup Language) files. For every new XML file you create, you have to go to its properties and then point to the target schema located at ../TEMPLATE/XML/wss.xsd.

    If you don’t know what I mean, usually, in order to display IntelliSense in an XML file opened through Visual Studio, we must link the XML file to an XSD. This is done by going to the file properties and linking to the XSD every time we open the XML file in Visual Studio.

    One way to avoid having to link to the XSD every time, is to add the file(s) to a Visual Studio project. However, what if you create CAML files so frequently that you don’t want to add them to a Visual Studio project every time?

    The best solution would be to load the XSD whenever a new XML file referencing it is opened; and I have the steps to do that!

    Under the Schemas folder of the Visual Studio installation folder (Ex: C:\Program Files\Microsoft Visual Studio 9.0\Xml\Schemas), there is a file named Catalog.xml.

    Reference wss.xsd from it by adding the following tag:

    Make sure that href is pointing to the correct location of the wss.xsd file.

    <Schema href="C:/Program Files/Common Files/Microsoft Shared/Web Server Extensions/12/TEMPLATE/XML/wss.xsd" targetNamespace="http://schemas.microsoft.com/sharepoint/" />


    Ali B

Compose new post
Next post/Next comment
Previous post/Previous comment
Show/Hide comments
Go to top
Go to login
Show/Hide help
shift + esc

Get every new post delivered to your Inbox.

%d bloggers like this: