Compartilhar via

How to Install SQL Server 2008 R2 (Express Edition)

  • Artigo

Overview:

With the release of the SQL Server 2008 R2 November, we have simplified the SQL Server Express (all editions and package) installation process.  In this release, we have completed the following:

  1. Reduced the number of clicks by 50% when performing an install.
  2. All inputs are defaulted on Vista and above operating systems.  (many inputs are defaults on Windows XP and Windows 2003, except for the service accounts)
  3. Skip (auto advance) through the UI, meaning non-essential dialogs will still be skipped.
  4. Reduced the size of the Express basic package

 

Available Express editions for download:

Express Package

If your system is?

If your system is?

If your system is?

Microsoft® SQL Server® 2008 R2 Express

X86

X64

WOW64

Microsoft® SQL Server® 2008 R2 Express with Tools

X86

X64

.

Microsoft® SQL Server® 2008 R2 Express with Advanced Services

X86

X64

.
Microsoft® SQL Server® 2008 R2 Management Studio Express

X86

X64

.

 

Below I show the steps to install SQL Server 2008 R2 Express.

1. Launch the package, you will then see the contents extracted to a temporary location.

image

 

2. SQL Server Setup checks to determine pre-reqs are installed. If not, you will be prompted to install.

 image

3. The Installation Center will then launch. Click on “New installation or add feature to an existing installation” to start the Installation Wizard.

image

 

4. Accept the license terms.

image

 

5. Review the features to installed and where SQL Server will be installed. Make any changes that are necessary for your environment.

image

 

6. Review the Instance Name and change if necessary.

image

 

7. Review the credentials that will be used for the services that will be created. 

image

 

8. Review the Authentication Mode and the administrators that will be added to the Database Engine.

image

 

9. Review the Error Reporting settings. We encourage you to keep this option checked, as we review the product feedback on an ongoing basic.  This helps us to continually improve SQL Server.

image

 

10. That’s it!

image

 

Support/Feedback

If you have further questions or feedback, you have a few options:

Comments

  • Anonymous
    November 13, 2009
    Thank you!!!! This is much easier! Any work done on automated installs failing alot?  We're constantly dealing with failed installs that we hvae to do a manual gui install with the same options and then it works just fine (in fact we use the same script and just remove the silent flag and just click next a bunch of times)

  • Anonymous
    December 17, 2009
    Can we have the bootstrapper for the server with tools?

  • Anonymous
    December 18, 2009
    If you take a look at http://www.microsoft.com/downloads/details.aspx?FamilyID=c772467d-e45b-43e1-9208-2c7b663d7ad1&displaylang=enc, there is a package that contains the database engine and tools. I just did not include the link here...

  • Anonymous
    December 18, 2009
    I've seen it but I was referring to the bootstrap packages so that we can distribute easily this latest release with our applications directly from VS.

  • Anonymous
    August 03, 2010
    You won't get a bootstrapper - connect.microsoft.com/.../sql-server-express-2008-r2-bootstrapper-package

  • Anonymous
    August 17, 2010
    Hi! I don´t know what am I doing wrong. I have Windows Vista SP2 in Spanish, but cannot install SQL Server 2008 EXPRESS R2 in Spanish. So, I tried the English (ENU) version. It installed, but never asked me for the instance or anything. And in the end I think it didn't installa any instance at all, because, although I have the Managment Studio, there appears to be no database to logon. It's all weird indeed. Thansk for any advice, like the precise link to download the actual installer. Maybe I'm just installing the Managment Studio... I honestly do not know!

  • Anonymous
    September 19, 2010
    Hi, I'm running Windows XP sp2 and wanted to install a few web development tools with the web platform installer...I figured I need SQL Server Express so I selected downloads for all the SQL server options. I ended up with SQL Server 2008 AND SQL Server 2008 r2. That seems to create a problem because both installation center wizards don't work correctly...keep on prompting me for folders to select and when I select it comes up with an error message saying the selected folder is not a valid installation folder. Can I remove one of the versions?Without affecting installation files of the other?How do I go about this? I have all the other requirements. Please Help

  • Anonymous
    November 07, 2010
    The comment has been removed

  • Anonymous
    November 07, 2010
    The comment has been removed

  • Anonymous
    November 10, 2010
    How many users can sign on to SQL Server 2008 R2 Express ?  

  • Anonymous
    November 10, 2010
    How many users can sign on to SQL Server 2008 R2 Express ?  

  • Anonymous
    November 11, 2010
    I finally figured it out yesterday. Yes, I have installed a SQL server 2008 R2 Express with advanced features on another laptop with 64 bit Win7 pro OS.

  • Anonymous
    January 04, 2011
    If I am not mistaken, SQL Server 2008 R2 Express is a single user license. You might want to check and confirm that on Microsoft SQL Server 2008 R2 release notes.

  • Anonymous
    January 04, 2011
    If I am not mistaken, SQL Server 2008 R2 Express come with a single user license. You might want to check and confirm that on Microsoft SQL Server 2008 R2 release notes.

  • Anonymous
    January 04, 2011
    Lian, If I am not mistaken, SQL Server 2008 R2 Express come with a single user license. You might want to check and confirm that on Microsoft SQL Server 2008 R2 release notes.

  • Anonymous
    January 20, 2011
    Thanks for the instructions, the installation was alright. But... After the installation, when I try to open the SQL Server Management Studio and logon to the local database, I get each time this error below: TITLE: Connect to Server

Cannot connect to (local).

ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) For help, click: go.microsoft.com/fwlink

BUTTONS: OK

I already re-installed it several times and each time I get the same error :( Is someone able to help me? Thanks. James Is

  • Anonymous
    January 23, 2011
    You have to specify the TCP Port (1433) under SQL Server Network Configuration - Protocols. Choose TCP/IP, Properties, IP Addresses tab and under IP All specify 1433 for TCP Port. I've just did it for a SQL Server 2008 R2 ITA version and it worked perfectly. Ciao, Ivano

  • Anonymous
    January 31, 2011
    Thanks Ivano, but I checked and the port 1433 was already set by default. Some other other idea? Thanks. James.

  • Anonymous
    February 02, 2011
    try turning off your local firewall just to see if it is blocking the connection port

  • Anonymous
    February 15, 2011
    How do I get to the  64-bit downloads. They are hidden beneath the right sidebar.

  • Anonymous
    February 24, 2011
    pod, all download options are available here: www.microsoft.com/.../InstallOptions.aspx

  • Anonymous
    March 16, 2011
    I installed Windows installer 4.5 . And then installed SQL Express 2008 R2. Installation fails with the comment "System requires a reboot" .How can I avoid this restart?

  • Anonymous
    July 04, 2011
    This is great, but the equivalent commandline for UNATTENDED installation of SQL Express R2 is......?

  • Anonymous
    July 21, 2011
    I got this ERROR.... TITLE: SQL Server Setup failure.

SQL Server Setup has encountered the following error: The system database file master.mdf already exists in C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLDATA. Error code 0x84B40000.

BUTTONS: OK

  • Anonymous
    July 26, 2011
    Which version should I have Windows 7 as OS?

  • Anonymous
    October 01, 2011
    Helped me a lot during the service account config

  • Anonymous
    October 31, 2011
    page formatting has changed hiding the right portion of the express download page...... Thanks Don

  • Anonymous
    January 26, 2012
    Hi, I was trying to install the Microsoft SQL Server 2008 r2 express edition after uninstalling it a  week ago... but while installing it , it just keep not going after the "License Terms" window. It couldn't go further to the "Feature selection " window... I have tried so many times restarting but the situation never solved. it always takes me back to the "SQL Server installation center" window.... Please solve my problem. Thank you!

  • Anonymous
    February 28, 2012
    Hi, I am having the same problem as Joe. Can anyone help? It does not take me to the select feature page? BTW, i am trying to install in vista service pack 2. Thank you in advance.

  • Anonymous
    March 04, 2012
    Hi all, I have tried to install SQL 2012 on Windows Server 2008 R2 and Windows 7 home premium. During installation, it does not ask for any about instance creation. After installation, no instance was created at all. And, I can't find any method to create an instance. Does anyone could help me out? Many thanks! Justin

  • Anonymous
    August 12, 2012
    Does it support windows 8... ?? please want to install in windows 8 thanks :)

  • Anonymous
    November 22, 2012
    The comment has been removed

  • Anonymous
    December 07, 2012
    Not able to connect to sql server 2008 from visual studio 2010. what should be the connection string? Data Source=    ??      ;Initial Catalog=(database name);Persist Security Info=True;User Id=      ??;Password=     ??     " what should it be for windows authentication and sql server authentication?

  • Anonymous
    December 31, 2012
    it installed successfully but dint show any  connection how can i connect it with data base as i clicked over it it just shows installation center nothing more what can i do kindly reply and guide me

  • Anonymous
    January 07, 2013
    when i am isnstalling microsoft sql server 2008 R2 "the specified folder is not a valid directory" this error is coming ..... what will i do...do help me please

  • Anonymous
    February 21, 2013
    how to find the sqlserver name after installing the softwere pls help to me

  • Anonymous
    March 06, 2013
    I am having the same problem as Joe. Can anyone help? It does not take me to the select feature page? BTW, i am trying to install in window sever service pack 1. http://www.itkomp.com

  • Anonymous
    April 12, 2013
    sir,         i am getting the error while installing sql server 2008 r2 please tell me the pre requirements my os is win 7 ultimate and i hav 2gb ram

  • Anonymous
    June 12, 2013
    how to know the ip address? and can i connect it to remote desktop?

  • Anonymous
    December 13, 2013
    Thank you very very much for such a good topic

  • Anonymous
    December 17, 2013
    salam to every one there is some problem in connectivity as iam is unable  to connect the server name. kindly do some instructions. thanks.

  • Anonymous
    February 23, 2014
    I installed both a test and production version of SQL Server Express 2008R2.  The test I choses the default settings c: Program files and it works fine. Production I chose the e: drive for installation but I cannot connect to it - any suggestions would be greatly appreciated....

  • Anonymous
    March 17, 2014
    it's very helpful ..Thank you so much

  • Anonymous
    April 20, 2014
    Thank for every one it is usefull for every one...... ==================================

  • Anonymous
    June 07, 2014
    But after installing  i am not getting where to open.it

  • Anonymous
    February 13, 2015
    is this exist "database mail" functionality?

  • Anonymous
    June 10, 2015
    after install program show only configuration file only .....y...?

  • Anonymous
    July 08, 2015
    TITLE: Connect to Server

Cannot connect to SQLExpress.

ADDITIONAL INFORMATION: Une erreur liée au réseau ou spécifique à l'instance s'est produite lors de l'établissement d'une connexion à SQL Server. Le serveur est introuvable ou n'est pas accessible. Vérifiez que le nom de l'instance est correct et que SQL Server est configuré pour autoriser les connexions distantes. (provider: Fournisseur de canaux nommés, error: 40 - Impossible d'ouvrir une connexion à SQL Server) (Microsoft SQL Server, Error: 53) For help, click: go.microsoft.com/fwlink

BUTTONS: OK

  • Anonymous
    August 18, 2015
    Before install Sql Server 2008 r2 Install  visual Studio 2010?