How To Install Sql Developer On Windows 10

Summary: in this tutorial, you lot volition learn to install the SQL Server 2019 Developer Edition and SQL Server Management Studio (SSMS).

Install SQL Server 2019 Developer Edition

Download SQL Server 2019

To download SQL Server 2019, you click the post-obit link:

Download the SQL Server

Microsoft provides yous with some SQL Server editions. For learning purposes, you can download the Developer edition.

Once complete downloading, yous tin can double-click the fileSQL2019-SSEI-Dev.exe file to launch the downloader.

1. The downloader will ask you to select the installation type, cull the Download Media pick. This option allows you lot to download the setup files first and install the SQL Server later.

2. Specify the folder for storing the installation files, then click the Download push button:

iii. The downloader will starting time downloading the installation files. It'll have a while.

4. Once the download completes, open up the binder that stores the downloaded file:

five. Correct-click the iso file and select the Mount selection to mount the iso file:

6. Open the installation folder and click the setup.exe file to launch the installer:

Install SQL Server 2019 developer edition

1. After double click setup.exe, you lot'll run across the post-obit window; select the installation option on the left:

2. Click the starting time link to launch a wizard to install SQL Server 2019:

3. Specify the edition that y'all want to install, select Developer edition, and click the Next push button.

4. Select the "I accept the license terms." and click the Next push button:

5.  Uncheck the "Use Microsoft Update to check for updates (recommended)" if you don't want to go the updates for the SQL Server and click the Side by side button:

6. The installation checks for the prerequisites before installation. If no error occurs, click the Side by side push button:

seven. Select the features that y'all want to install. For learning purposes, you demand the Database Engine Services; check the checkbox and click the Next button to keep:

viii. Provide the instance ID of the SQL Server and click the Next button:

9.  Select the Mixed Style, provide the password for system administration (sa) account (y'all need to store this password in a secure place so that y'all tin can use it to connect to the SQL Server later), click the Add together Electric current User to specify the SQL Server Administrators, and click the Adjacent button:

10. Verify the SQL Server 2019 features to exist installed:

11. Click the Close button to complete the installation:

Congratulation!  you lot take successfully installed SQL Server 2019 Developer Edition.

Install Microsoft SQL Server Management Studio

To interact with SQL Server, you need to have a SQL Server customer tool.

Microsoft provides you with the SQL Server Management Studio (SSMS). The SQL Server Management Studio is software for querying, designing, and managing SQL Server on your local calculator or in the cloud. It provides you with tools to configure, monitor, and administer SQL Server instances.

Outset, download the SSMS from the Microsoft website via the following link:

Download SQL Server Management Studio

Second, double-click the installation fileSSMS-Setup-ENU.exe to launch the SSM installer. The installation procedure of SMSS is straightforward. you demand to follow the screen sequence.

i. Click the Install button

ii. Wait for a few minutes while the installer sets upwardly the software:

3. In one case setup is completed, click the Close button:

Now, you should have SQL Server 2019  and SQL Server Management Studio installed on your computer. Next, you will learn how to connect to the SQL Server 2019 from the SQL Server Management Studio.

Source: https://www.sqlservertutorial.net/install-sql-server/

Posted by: rodriguezyoughter.blogspot.com

Share this post