Installing Microsoft SQL Server

Installing Microsoft SQL Server

This article will walk you through installing and configuring SQL Server for a migration workstation.

 

  1. Visit https://www.microsoft.com/en-us/sql-server/sql-server-downloads and scroll down just a bit until you see Developer and click the Download now button located below, then run the downloaded installation file.
  2. Once it finishes downloading, click on it to open the Installer
  3. Click Custom
  4. If you wish to change the location of the download media you may do so on this screen.  Generally the default is fine
    Click
    Install
  5. Click Installation on the left and then New SQL Server standalone installation or add features to an existing installation
  6. On the first screen the edition should already be set to Developer. 
    Confirm that it is, if not, change it to Developer
    Click
    Next
  7. Accept the license terms
    Click
    Next
  8. Click Next through the following series of settings pages to use the default settings until your reach the Azure Extension for SQL section.
  9. In the Azure Extension for SQL  screen
    Uncheck Azure Extension for SQL Server 
    Click
    Next
  10. On the Feature Selection screen check Database Engine Services
    Click Next
  11. On the Instance Configuration screen choose Default instance
    Click Next
  12. On the Server Configuration screen just click Next
  13. On the Database Engine Configuration screen
    1. select Mixed Mode
    2. Click Add Current User
    3. Click Add

    DO NOT click Next yet
  14. When you click Add you will see the following dialog.  Type the word 'Administrators' in the white text box and click the Check Names button.
  15. It should recognize the Administrators group and update the text box to look similar to the second image below.
    Click 
    OK
  16. Go to the FILESTREAM tab.
    C
    heck Enable FILESTREAM for Transact-SQL access

    Check Enable FILESTREAM for file I/O streaming access
    Check Allow remote clients access to FILESTREAM data

    DO NOT click Next yet

  17. Go back to the Server Configuration tab
    Enter a strong password for your SQL Server that you will remember
    Click
    Next
  18. Click Install in the Ready to Install screen
  19. Click on the start menu and type Run. Open the 'Run' application
  20. Type services.msc and click OK
  21. This will open a list of services running on your computer.  Scroll down until you find SQL Server (MSSQLServer)
    Right-Click and choose Properties
  22. Click the Log On tab and select Local System account
    Click
    OK
  23. You will receive a dialog indicating that the service must be restarted for your changes to take effect.
    Click OK
  24. Right click the SQL Server (MSSQLServer) service again
    Click
    Restart

    • Related Articles

    • Installing SQL Server Management Studio (SSMS)

      This article will walk you through installing and configuring SQL Server Management Studio (SSMS). If you have not already installed SQL Server, you should do so prior to installing SSMS. Visit ...
    • How to Configure SQL Server RAM Limits

      This article will guide you through setting up RAM limits for Microsoft SQL Server to ensure optimal performance while leaving sufficient resources for the operating system and other applications. Launch SQL Server Management Studio (SSMS) Click Open ...
    • Microsoft Visual C++ 2022 Redistributable Package

      This article will guide you through the installation of the Microsoft Visual C++ 2022 Redistributable Package, which is essential for running applications built with Visual C++ 2022, including MySQL Community Server. Go to Microsoft Visual C++ ...
    • Installing TreeSize (Free)

      TreeSize is a powerful disk space analyzer tool for Windows that helps you identify how your storage space is being used. It provides detailed reports and visualizations, making it easier to manage your files and folders. The following instructions ...
    • Installing Postgres SQL

      The following instructions describe how to install PostgresSQL. You will need to complete the following two tasks Install PostgresSql Configure PgAdmin 4 Install PostgresSQL Go to this link and download the most recent version at the top of the list: ...