Updates from September, 2010 Toggle Comment Threads | Keyboard Shortcuts

  • Ali BaderEddin 2:16 am on September 28, 2010 Permalink | Reply
    Tags: createunattend, unattendfile   

    Visual Studio 2010 – Unattended Silent Install 

    You can find on MSDN How to: Create and Run an Unattended Visual Studio Setup. This post focuses on unattended installation of VS 2010 product only (without SDK) along with screenshots and hints on what to avoid. Below are the steps I have followed to create a silent unattended installation script for VS 2010.

    • Create the VS 2010 unattend configuration file
      <path to VS installation folder>\setup\setup.exe /createunattend c:\VS2010Config.ini

      Note: Make sure you run the \setup\setup.exe and not \setup.exe directly.

    • The wizard will launch… Accept license terms, select the feature you want to install, then click Save Settings.
    • Once you click “Save Settings”, the VS config file will be created at c:\VS2010Config.ini
    • Now, do the unattended installation with the command below
      <path to VS installation folder>\setup\setup.exe /unattendfile c:\VS2010Config.ini

    As you can see, the steps are pretty straight-forward. Enjoy!

    • serman durai 5:39 pm on January 25, 2012 Permalink | Reply

      i followed your step to make inf file .but i am not able to find save settings options .in that same place next options is there .Would pls help me for inf file

    • Ali BaderEddin 11:31 pm on January 25, 2012 Permalink | Reply

      Make sure you are running \setup\setup.exe not \setup.exe

      • Sudhakar 6:25 am on January 13, 2014 Permalink | Reply

        Hi Ali,

        Thanks for wonderful hint for Unattended silent Installation of VS 2010….

    • Livio 3:16 am on September 11, 2012 Permalink | Reply

      Just click “Next”, then accept the License, there you can now chose if you want to save the full settings or custom settings (chose between Full or Custom and click Save Settings).
      For me that all worked but when I try to use it it tells me the file is wrong or something. I’m using PowerShell to chose the file.

    • Livio 3:24 am on September 17, 2012 Permalink | Reply

      Forget it. It works now.

    • Honza 3:01 am on October 3, 2014 Permalink | Reply

      Works good. Thank you very much.

    • shakthivel 10:38 pm on November 25, 2014 Permalink | Reply

      hi its saying unable to create.in file,how to resolve this

  • Ali BaderEddin 12:43 am on September 28, 2010 Permalink | Reply
    Tags: , 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?

    • 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 11:08 pm on June 8, 2010 Permalink | Reply
    Tags: AllowWindowsClientInstall, optimizeCompilations, SharePoint Designer, SharePointFoundation, standalone, windows 7   

    SharePoint Foundation 2010 on Windows 7 

    This MSDN article describes in detail how to install SharePoint Foundation 2010 for development purposes on Windows Vista, Windows 7 and Windows Server 2008. The purpose of this post is to focus on the SharePoint installation on Window 7 only and clear out all the details for the other operating systems.

    1. Download SharePoint Foundation 2010 x64 for free. Note that there is no x86 version of SharePoint Server, so don’t bother setting it up if you have a 32-bit machine.
    2. Create a new folder “C:\SharePointFiles” and copy “SharePointFoundation.exe” to it.
    3. Start command prompt, change directory to C:\SharePointFiles and run the following command to extract the “SharePointFoundation.exe” to C:\SharePointFiles
      SharePointFoundation.exe /extract:C:\SharePointFiles
    4. Open C:\SharePointFiles\files\Setup\config.xml, add a new <Setting> tag under the <Configuration> element, then save the file. Make sure you copy the below element as is since all of the text in the configuration file is case-sensitive.
      <Setting Id=”AllowWindowsClientInstall” Value=”True”/>
    5. Install the following Prerequisites:
    6. Enable the required windows features by running this batch file: http://cid-e38f9fc6490b29d9.skydrive.live.com/self.aspx/Public/Scripts/EnableSPWinFeatures.bat
    7. Restart your computer to complete the changes that you made to Windows Features.
    8. Install SharePoint 2010
      • Run Setup.exe under C:\SharePointFiles
      • Select standalone (Windows 7 can’t be used for production deployments of SharePoint 2010 and it’s recommended that you use Standalone only)
      • After the installation is complete, you will be prompted to start the SharePoint Products and Technologies Configuration Wizard.
    9. After a SharePoint solution (.wsp file) is deployed, it recycles the application pool. To improve the initial page load times, set the optimizeCompilations property of the <compilation> tag in your web.config file (C:\inetpub\wwwroot\wss\VirtualDirectories\80\web.config) to true.
      <compilation optimizeCompilations=”true”>

    SharePoint Designer 2010 is also free and can help you better design your SharePoint site(s). You can download it here.

    • Ravi 10:09 pm on August 1, 2010 Permalink | Reply

      Hello Sir,
      I want to develop an application in .net, that will read XML file. and will convert that code into any language such as C, C#, Java. But I am not getting How to start..
      Thank You.

    • Bas 12:51 am on September 13, 2010 Permalink | Reply

      Hey, I am trying to install spf 2010 on my Windows 7 machine. Works for me till step 4. I changed the config.xml file on location C:\SharePointFiles\Files\Setup\config.xml to:

      *Without linebreaks ofcourse.

      When I run the Setup I get the following Setup error:
      This product requires Windows Server 2008 Service Pack 2 or above.

      Do you have any idea what is going wrong?

      Thank you!

    • Bas 12:53 am on September 13, 2010 Permalink | Reply

      Can I show my code?

    • Bas 12:54 am on September 13, 2010 Permalink | Reply

      Probably not..

    • Ali BaderEddin 2:34 pm on September 13, 2010 Permalink | Reply

      What exactly are you blocked on in step 4?

    • Alessandro 7:32 pm on December 21, 2010 Permalink | Reply

      Hi guys,

      I’ll use Sharepoint in my company (~20 users) to act like a ECM, just for document repository, some permission roles, etc.

      I have a Quad-core PC with 4 GB RAM and Win7 64-bits installed. JIRA applications are already installed on this machine.

      Can I also install the Sharepoint Foundation 2010 for production in this machine, just for 20 users??? My question is, will I have performance issues???

      Thank you.

    • Ali BaderEddin 1:23 pm on December 23, 2010 Permalink | Reply

      Alessandro, I don’t have an answer to your question. That depends on how much traffic the 20 users put on the site.

      I would recommend having 8GB RAM on that machine given that there will be multiple IIS, SQL server, SharePoint timer service and User Code service processes running on that machine. Add to that the JIRA applications that you have, which I have no clue how much memory they’d consume.

    • Pachy 3:36 pm on January 19, 2011 Permalink | Reply

      I did all the steps but i got a blank page…what should I do??

    • Peter Cooper 7:39 am on January 25, 2011 Permalink | Reply

      Thanks for this. Was really useful and worked fine for me. You need to watch out if you copy-and-paste the XML line because the quote marks appear as ascii #148.

    • Doug Fisher 3:05 am on April 13, 2011 Permalink | Reply


      I have followed the above procedure but hit two snags:

      1 The batch file returns an error about an incorrect format
      2 Running Setup.exe gives an error regards the config.xml file. It says it is not valid. I have copied as instructed, so what is this about?

      My W7 is installed on VM Workstation 7

      Any help is greatly appreciated

      • Sharique Khan 10:33 pm on July 12, 2011 Permalink | Reply


        I was also facing the problem with the config file. The issue is in this blog in the opening quote for attribute is ” instead of “. So if you do a direct copy paste you will encounter the problem of xml invalid.

    • mayuri 8:29 am on September 28, 2011 Permalink | Reply

      Thank you very much for this post. I was successfully in setting up sp foundation on windows 7.

    • Michael J Murton 6:04 am on April 19, 2012 Permalink | Reply

      Hi, I am running into the same config.xml invalid error when I try to run setup.exe for SharePoint Foundation 2010. Is there a valid xml file that I can copy and paste? Any help would be appreciated. tx Mike

    • maiomar86 10:56 pm on September 11, 2012 Permalink | Reply

    • Scott 2:13 pm on December 13, 2012 Permalink | Reply

      Great article. The only problem I had was within editing the element, it didn’t like your quotes. I deleted them and added them back and worked as described. Thank you for doing this.

    • John 6:02 pm on June 5, 2013 Permalink | Reply

      I had to remove and readd the double quotes (4) and use initial caps on Id and Value. Then setup.exe was able to run without erroring on the config file.

    • Justine 3:11 am on August 26, 2014 Permalink | Reply

      This excellent website definitelyy has all of the information and facts I
      wanted concerning this subject and didn’t know who to ask.

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.

Join 25 other followers

%d bloggers like this: