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. Click Next through the following series of settings pages to use the default settings until your reach the Edition section.

  7. On the first screen the edition should already be set to Developer.  Confirm that it is, if not, change it to Developer and click Next
  8. Accept the license terms and click Next
  9. Click Next to accept the default options until you get to the Azure Extension for SQL screen.
    Uncheck Azure Extension for SQL Server and click
    Next
  10. On the Feature Selection screen check Database Engine Services and click Next
  11. On the Instance Configuration screen choose Default instance and 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.
    Check 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
    Go back to the Server Configuration tab

  17. Enter a strong password for your SQL Server that you will remember.  Click Next
  18. Click Next to accept defaults on remaining screens and then click Install when you get to 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 and 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 ...
    • 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 run the installer for Postgres Sql: Community DL Page ...
    • Installing Windows

      Installing Windows If you are installing Windows to a laptop, be certain it is plugged in throughout this process. 1. Run the installer using the media of your choice. 2. Select your language, time zone, and keyboard layout, then click Next 3. Click ...
    • Installing Proxifier

      This article will help you configure Proxifier. Please ensure you have already installed and configured Fiddler. Configure Fiddler as a Proxy Server Go to Profile > Proxy Servers > Add Create a proxy server with the following values: Address: ...
    • Installing Team Viewer

      This article will walk you through installing Team Viewer so you can remotely access your migration workstation. Download TeamViewer Full Client 1. Visit TeamViewer.com 2. Download the TeamViewer FullClient installer. Their website may change, but as ...