1a. Install MS SQL Express Server

Applies to ReadyAPI 3.10, last modified on October 07, 2021

For the purposes of this tutorial, you will use a simple installation of MS SQL Express (the free limited version of MS SQL Express).

Some particular things to note for this tutorial:

  • Named Instance – The default setting for MS SQL Express is to be installed as a named instance. You will need this when working with this tutorial. For more information, see https://technet.microsoft.com/en-us/library/ms165614.

  • Fixed Port – By default, SQL Server Express does not always use the same port and just grabs whatever port is available. You should confirm the port is fixed in the SQL Server. In this tutorial, you will use port 1433. For more information, see https://msdn.microsoft.com/en-us/library/ms177440.aspx.

  • Authentication Mode – SQL Server will usually use NTLM if connecting locally, or Kerberos if connecting remotely. For more information about NTLM, see the Microsoft Knowledge Base.

If you need more information about the installation procedure, the installation guide is available at https://technet.microsoft.com/en-us/library/ms143722.

Installation

To install the MS SQL Express server:

  1. Download the MS SQL Express Installer from the MS SQL Express web site: https://www.microsoft.com/en-US/download/details.aspx?id=42299.

    MS SQL Express download page

    Click the image to enlarge it.

    Once you click the Download button, you will be prompted to select the files you need. Select either the ExpressAndTools or the ExpressAdv version of the required bitness (32-bit or 64-bit), since these versions include SQL Server Management Studio you will use in this tutorial.

    Click Next to start downloading.

    MS SQL Express: choose the download

    Click the image to enlarge it.

  2. Once the download is complete, run the installer.

    MS SQL Express extraction
    MS SQL extraction in progress
  3. Select New SQL Server Stand-Alone Installation.

    MS SQL Express: Starting the installation

    Click the image to enlarge it.

  4. Check I accept the license terms if you do. Click Next.

    MS SQL Express: License agreement dialog

    Click the image to enlarge it.

  5. On the Feature selection step, make sure to uncheck the LocalDB option. You will not need that during the tutorial.

    MS SQL Express: Feature Selection step

    Click the image to enlarge it.

    You will use a named instance, so the exact name is not important. Remember it just in case.

    Note: For more information about Named Instances, see https://technet.microsoft.com/en-us/library/ms165614.

    Click Next.

  6. On the Feature Rules step, just click Next.

  7. On the Instance Configuration step, just click Next

    MS SQL Express: Instance Configuration step

    Click the image to enlarge it.

  8. You do not need to make any changes on the Server Configuration step, since the default account configuration works fine for the purposes of this tutorial.

    MS SQL Express: Server Configuration step

    Click the image to enlarge it.

    Click Next.

  9. You do need to change the Data Directories, User Instance, or FILESTREAM settings. Still, when working with this tutorial, you will use the Mixed Mode authentication for maximum flexibility, so choose that Authentication Mode and enter and confirm a server administrator (sa) password.

    Note: Make sure to remember the password you have entered.

    MS SQL Express: Database Engine Configuration step

    Click the image to enlarge it.

    Click Next.

  10. The server will be installed.

    MS SQL Express: Installation in progress

    Click the image to enlarge it.

  11. When the installation is complete, click Close.

    MS SQL Express: Installation is done

    Click the image to enlarge it.

Now, you can configure the port.

Prev          Next

See Also

Microsoft SQL Databases as Data Sources

Highlight search results