SQL Server 2019

Owned by Timothy Hitchcock
Last updated: Mar 23, 2021 by Paul Hitchcock
2 min read

Download MS SQL Server Express 2019.

  1. Navigate to the file location and run the downloaded file.

  2. Windows UAC will prompt you with a warning. Select Yes to continue. Select Basic.

  3. Read the License Terms and click Accept to continue.

  4. Verify the install location and click Install to begin installation.

Install SQL Server Management Studio (SSMS)

When installation of SQL Server is complete, you may opt to install SQL Server Management Studio (we Recommend installing this).

If the installer doesn’t offer a link to download SSMS here is a link to their download page: SQL Server Management Studio

Click Close to complete the installation. You can now close the SQL Server installer window as well. In some instances, a restart may be required.

Now, navigate to the start menu and find Microsoft SQL Server Management Studio. Click on the app to launch SSMS.

Next, You'll be greeted with the Connect to Server window. Enter your server path in Server Name, and then click Connect. Note: If you are installing this from your server, the server name should default to the SQL Express installation.

If you entered the information correctly, you will see your server in the object explorer window with a green "play" button indicating you have connected to your server through SSMS.

Next, right-click your server in the Object Explorer window and select Properties.

The Server Properties window will now appear. Click Security in the Select a page pane. Below Server authentication, select the radio button next to SQL Server and Windows Authentication mode. Now, select OK to close the window. You can now exit SSMS.

You are now ready to install Crows Nest.