How to perform an unattended installation of SQL Server 2008 Express
A while ago I wrote an article called “How to perform an unattended installation of SQL Server 2005 Express“. With the release of SQL Server 2008 it’s time to write another one about how to do the same but for SQL Server 2008 Express. So, let’s get started …
Unattended installations of SQL Server can be as involved as you want – pretty much every option can be specified in the configuration file. For this example I’m going to perform a relatively basic installation with minimal customisation so you can see the process at work. The installation will specify most of what I think are the critical options you’ll be interested in. Note that for this example I’m using the x86 (32-bit) version with advanced services.
Assumptions:
- You’ve downloaded the x86 (32-bit) version of SQL Server 2008 Express from the Microsoft Microsoft SQL Server 2008 Express website
- Your system meets the requirements for installing SQL Server 2008
- You are installing from C:\Install\SQL2008 (you can change this as necessary but please make sure you update the paths in the examples below)
- You’ll save your configuration file as C:\Install\sql-2008-express.ini
Once you’ve satisfied those requirements follow the steps below.
- Run the executable you downloaded with the /x parameter (e.g. C:\Install\SQL2008\SQLEXPRADV_x86_ENU.exe
- Choose a location to extract the installation files to.
- Create a new text file that will become the unattended installation configuration file. Leave it empty for now.
Now that you’ve got a nicely extracted copy of the installation files you can carry on. The above steps were necessary for what’s coming up.
So, you can now create your own configuration file using Microsoft’s documentation or you can use the version I’ve included in this article.
Be careful with the Microsoft documentation as there is an error on the page called How to: Install SQL Server 2008 from the Command Prompt. It mentions a parameter called /BROWSERSVRACCOUNT but this should be /BROWSERSVCACCOUNT. If you get this wrong the installation WILL fail.
You can download the configuration file I’ve made below. The changes I’ve made are as follows (you may need to change these to match your settings).
- Set the QUIETSIMPLE parameter to “True”.
- Set the MEDIASOURCE parameter to the appropriate installation path.
- Added a parameter called SAPWD and set it to the strong ’sa’ password.
- Set the INDICATEPROGRESS parameter to “True”.
- Set the SQLSYSADMINACCOUNTS value to “MYPC\Administrator”.
Once you have your answer file all nicely setup and ready to use you’ll need to tell the setup program how to use it.
From a command prompt (or Start > Run if you’re into that) run the following command. Remember to change the file and path names to the ones that match your system.
If you’ve done everything right this will start the installation process and you’ll end up with a SQL Server 2008 instance called SQLExpress running on your system. Easy!
Related posts:
- How to perform an unattended installation of SQL Server 2005 Express To continue on with the theme of unattended installation-related posts...
- How to perform an unattended installation of SQL Server Management Studio Express If you’re a user of SQL Server 2005 Express you...
- How to perform an unattended installation of SNMP on Windows Server 2003 Continuing with the recent history of unattended installation articles, this...
- SQL Server 2005 Express Unattended Install – Further Info Recently I posted an article about how to perform an...
- How to perform an unattended installation of IIS7 There’s not a lot of point having an article on...
3 Responses to “How to perform an unattended installation of SQL Server 2008 Express”
Leave a Reply
These instructions DO NOT WORK, I have spent 2 hours trying to figure out why this doesn’t work and no luck
What do I do now?
foxjazz – The steps above DO work but I have found a problem with the unattended installation file. If you were using the file I made available for download you are correct, it would not have worked. The change was setting the AGTSVCSTARTUPTYPE value to “Manual” instead of “True”. Don’t forget to also change MYPC\Administrator to the appropriate credentials for your system. Thanks.
hello,Chris.thank you for your instructions.now this script WORK well. but my sql server 2008 express is japanese version. the datebase date is not correctely showing . maybe the code is not right. where i should modify the script? thank you.