How To Setup Sql Server In Windows 10

Introduction

In this article, we are going to install Microsoft SQL Server on windows machines step by step. In this tutorial, we are going to use SQL Server 2019 Developer edition and Windows Server 2019.

Pre-requisites

Windows machine having two core and iv GB RAM configuration

Download SQL Server 2019 Developer Edition

First, let's download SQL Server installation media from the official website.

Step 1

Download installation media from this link.

Step 2

Run the downloaded file and yous will see the below screen. Now select the third option – Download Media.

Step 3

Now you will see the beneath screen. Please select the language yous adopt and select theISO radio button to download the ISO file. In add-on, select the download location of your option. I volition get with the default location. Now press theDownload button.

Step 4

Now information technology will start downloading SQL Server installation media. It will accept some time based on your cyberspace connection speed.

Step 5

Afterwards successful download of installation media, you will meet the below screen. Click theClose button.

Install SQL Server 2019 Developer Edition

Now that we accept installation media, nosotros tin can start the installation of the SQL Server. Permit'south encounter how to install SQL Server footstep by step.

Pace i

Run install media file (ISO file) downloaded in higher up section by double-clicking on it. It will extract/mount all the contents in a new temporary drive.

Paradigm ane - ISO file

Paradigm 2 – Extracted contents

Step 2

Once extraction is completed, double click on thesetup.exe file and you will see the below screen. Click on theInstallation option in the left panel and then click on New SQL Server stand-solitary installation or add features to an existing installation option from the correct panel.

Step 3

Now you volition encounter theProduct Central window. Select theDeveloper option from the dropdown and click on theNext push.

Step 4

Now y'all will see theLicense Terms window. Just select the checkbox and click on theSide by side button.

Step 5

Now you volition run across theMicrosoft Update window. It is not compulsory to check for the latest updates only it is recommended. So, select the checkbox and click theNext push button.

Step vi

Now information technology volition cheque for updates and install them if any.

Pace vii

After that, it will check some rules or prerequisites for the installation of SQL Server. Once all the rules passed, click on the Next button. Sometimes you may confront an error at this phase. You can discover some known errors at the end of this article.

Step eight

On theCharacteristic Selection window, select features as shown in the beneath screenshot. You tin can also alter the location for SQL Server instance installation merely I will go with the default location. Afterward feature choice please click theNext push button.

Image one – Features selection Epitome 2 - Features selection

Pace 9

It will check some feature rules/prerequisites and so you will see theInstance Configuration screen. Hither you can choose between Default Instance and Named Case. Here I volition go with Named Case.

Note

Default Instance

When SQL Server is installed in the default instance, information technology does not require a client to specify the name of the instance to brand a connection. The client only has to know the server proper name. For example, HARDIK-PC.

Named Instance

A named instance is identified past the network name of the computer plus the instance y'all specify during the installation. The client must specify both the server name and the example name when connecting. For example, HARDIK-PC/MSSQLSERVER.

Step 10

Next, you will encounter theServer Configuration window. In Service Accounts tab, select Automatic in Startup Type for SQL Server Agent, SQL Server Database Engine, and SQL Server Browser services.

In theCollation tab, select collation as per your preference.

"Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. Collations that are used with character data types, such equallychar andvarchar, dictate the code page and corresponding characters that can exist represented for that data type." – Microsoft.

Ref: https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver15

Footstep 11

Adjacent, you volition see theDatabase Engine Configuration window. In theServer Configuration tab, choose Mixed Manner in the authentication mode section and enter a potent countersign. In Specify SQL Server administrators department, your electric current windows user should already be added automatically. If not, click on Add together Current User push.

In theData Directories tab, specify locations for database files and backup files. By default, it saves all the files on a C drive but it is non recommended to store database files on an Os drive because if any OS-related issue occurs then we may lose our data. Therefore, I choose D drive on my local machine.

In theTempDB tab, there are configurations for the temporary database file(s). At that place are some best practices on how to configure temporary database files locations, the number of files, and their file sizes. Ideally, the number of the TempDB data files should match the number of logical processors. So I have a number of files to 2. If y'all are interested in deep dive into TempDB best practices, here is a very skilful article on it.

Next, in theMaxDOP tab, the maximum degree of parallelism (MAXDOP) is a server configuration selection for running SQL Server on multiple CPUs. It controls the number of processors used to run a single statement in parallel plan execution. Past default, the setup will advise value based on the system configuration. For more than information and best practices come across here.

Next, in theMemory tab, we can configure how much memory SQL Server example tin consume. By default, the installation procedure volition recommend you lot min and max memory allocation based on the system configuration on which information technology is going install. However, yous can change it. Here you can detect best practices for SQL Server memory configurations.

In theFILESTREAM tab, exit the checkbox unchecked considering we are non going to enable this feature. FILESTREAM, in SQL Server, allows storing these large documents, images, or files onto the file system itself. For more information, see here.

Click on theNext button.

Step 12

Next, the setup will check some feature configuration rules, and then theReady to Install window volition announced. This window shows the summary of all the features and configurations which we have done in the to a higher place steps. Once review the summary and click on theInstall push button.

Pace xiii

Now, the installation will start and information technology may take some time based on our configurations.

Step fourteen

After installation, information technology volition testify you lot the list of features and their installation status. If any error occurred, information technology will show here.

Congratulations! We have successfully installed SQL Server 2019 Developer edition on Windows motorcar. Side by side, yous tin can install SQL Server Management Studio to connect SQL Server and query SQL databases. Please follow below steps to install SQL Server Direction Studio.

Install SQL Server Management Studio

Get-go, let us download SQL Server installation media from the official website.

Step one

Download installation media from these link.

Step 2

Below file volition download.

Footstep iii

Run the downloaded file and y'all will see below screen. But click on the Install push button.

Step 4

It will outset installing direction studio. Information technology will have some time.

Pace v

Once installation finished, close the installation wizard and open start carte du jour and search for SQL Server Direction Studio. You volition encounter below awarding. Now, click on it to open the application.

Step vi

Next, you will see below screen. In Connect to Server window, you lot can see the SQL instance name, which we have merely installed. (Ref. Pace ix). You can connect an instance with either Windows Hallmark or SQL Authentication, which we have created in Step eleven.

Stride 7

Once yous successfully authenticated, you tin can see Object Explorer in which you tin can notice database list and other SQL objects.

Then, hope y'all understand how to install and connect SQL Server using SQL Server Management Studio.

Expected errors / bug

Sometimes you can face up some issues/errors at the time of installation of SQL Server. Beneath are some known errors:

.NET Framework 3.5 is missing - https://www.mssqltips.com/sqlservertip/6615/error-installing-microsoft-net-framework-3-5-sql-server/
An fault occurred for a dependency of the feature - https://techcommunity.microsoft.com/t5/sql-server-support/sql-server-2019-installation-fault-an-error-occurred-for-a/ba-p/998033

Side by side Pace

Configure Named Pipe and TCP/IP Settings to access SQL Server Database Instance from outside or from other computers in the local network. Please bank check my commodity for here.

Conclusion

Every bit yous can meet, It is very easy to install SQL server 2019 Developer edition and SSMS, if you follow steps accurately. It is a very user-friendly and polish installation. Then now, you can too install SSMS or other add-ons, which tin help you to heave SQL coding productivity.

Source: https://www.c-sharpcorner.com/article/step-by-step-installation-of-microsoft-sql-server-on-windows-system/

Posted by: maplethoposel.blogspot.com