SQL 2008: Installing SQL Express 2008

    Follow

    The following steps will show you how to install and configure SQL Express so Microvellum can use it in a network environment

    1. To get started, you will need to have Microsoft SQL Server Installed (Download SQL Server 2008 R2* here.  On that page, click on  the appropriate bit type for the computer where you will be installing SQL Express and pick SQL Server Express Database w/tools from the drop down box.

    *SQL Server System Requirements.

     2. After you download the file, launch the exe file and let the install initialize until it comes to the SQL Server Installation Center.  Here you can start a new install or you can upgrade an older SQL version.  Pick the new installation button. 

    Install-SQLExpress1.png                                                                                                

    3. The install will now scan your computer to make sure that is has the necessary support files on it.  If it does not it will pause the install until these are installed.  Most machines will have all the files it needs.  Older machines will be missing Windows PowerShell or .Net Framework Updates. The PowerShell install can be found at this website. http://support.microsoft.com/kb/968929/en-us

     

    • Once you have installed all the applications SQL Express needs, Click Re-Run and the application will rescan your computer.
     

    Install-SQLExpress2.png

     

    • Once it passed all applications, Hit Next.                                                                                                                                                                                           

     

    4. At the Feature Selection page, click Select All and then Continue.

    Install-SQLExpress3.png                                                                                                                                                                                                                           

     

    5. The Instance Configuration is the next step.  The default named instance is SQLEXPRESS.  This can be changed to whatever you desire.  Be sure to make a note of what it is called if you change it from the default as it will be needed later.  When you are ready select Next.

     

    Install-SQLExpress4.png                   

    6. The server configuration page is where the SQL Services are configured.  Under Account Name if either the SQL Server Database Engine or the SQL Server Browser is empty, then click on the drop down button and pick either the network or local service.  It is recommended that the Database Engine account name is the Network Service and the Server Browser account name is Local Service.   If there is no Network Service on the account name available, chose System.  Also verify that the Startup Type for both services is set to Automatic.  Verify that the options are configured as in the screen shots for best results. 

    Install-SQLExpress5.png 

    7. At the Database Configuration screen, in the Account Provisioning tab, switch the Authentication mode to Mixed Mode (SQL Server Authentication and Windows Authentication).  Enter a password for the SQL Administrator.    In this screen the SQL administrator can be added.  The System Administrator is added by default.  Basic users will be added later.

     

      • Also in the Database Configuration screen, in the Data Directories tab the default path to the databases can be altered if that is desired.  To do so find User database directory, User database log directory and change both of them to the desired location. 

    Install-SQLExpress6.png

     

    Install-SQLExpress7.png

     

    Select Next when configuration is complete.  The Install will now proceed and finish.  This could take up to a half hour. 

    Click here to continue with the configuration of your SQL Express

     

    Comments

    • Avatar
      Richard Laycock

      Nice job Seth.

      R.

    • Avatar

      Seth,

      While working in MV7 we are having issues with slow response times on our server install.  It takes longer for most tasks then it did for V67 which was also on our server.

      What is the recommended server spec for enabling MV7 to run quickly with up to 10 users.

    • Avatar

      Would like to know the answer to Mr. Richey's question as well.  We are getting ready to start wading into version 7 and have around 10 users.  Thanks.

    • Avatar

      Hello Seth do I have to go with SQL Server 2008 R2 or can I go with SQL Server 2014

      Thanks

      Mirek

    • Avatar

      Mirek,


      Good afternoon!  You can use SQL 2014.  The steps in this document are still accurate, just the interfaces have changed slightly.