Skip to content
Related Articles

Related Articles

How to Install SQL Server Client on Windows?

View Discussion
Improve Article
Save Article
Like Article
  • Last Updated : 24 Mar, 2022

The  Client / Server Application is a computer program that allows users to access what is stored on the server. Of course, both computers can be workstations running the same type of operating system. In most network environments, the server contains a database that requires users to access this database from their workstations. For a regular client/server database, you need to create the database first. As always, you have many options. In fact, you can start with something other than a database. To start the server, start Microsoft SQL Server from the computer where you installed Microsoft SQL Server or the workstation where you installed the client tools.

Installing SQL Client in Windows

Step 1: Open SQL Server installation center. In which the installation of SQL client is similar to an unboxing, but using setup.exe instead. The majority of the arrangement is the same as in 2016:  

Open-SQL-Server-installation-center

 

Step 2: When Setup.exe is launched, select the Installation tab from the left-hand menu.

Select-the-Installation-tab

 

Step 3: Setup.exe’s greater features.

Setup.exe-greater-features

 

  

Step 4: Select your preferred edition here I’m going with Developer.

Select-your-preferred-edition

 

Step 5: Developer Edition continues to call home, and you can’t turn it off. 

Developer-Edition-is-downloading

 

Step 6: Feature selection here I’ll accept the vast majority of the engine extras.

Feature-selection

 

Step 7: Choosing a name for your instance.

Choosing-a-name-for-your-instance

 

Step 8: Instant File Initialization isn’t checked by default when configuring service accounts. So select windows authentication mode.

Select-windows-authentication-mode

 

Step 9: Select your sysadmins carefully.

Select-your-sysadmins-carefully.

 

Step 10: Add location to save data in the data directories option.

Save-driver-location-in-data-directories-option

 

Step 11: Data and log files in TempDB can now be larger than a USB flash drive! However, there is a nice little warning popup about how you may have a delayed setup experience. Whatever you choose to call it, Filestream and then click next.

database-engine-configuration

 

Step 12: Now click on consent to install Python.

 

It hangs here for a bit after you click Accept before Next is enabled, and you have to click that as well.

Click-on-next

 

All systems are up and running-click Install.  

Installation-start

 

For me, the “CPU action” (or lack thereof) has always been the most time-consuming component of the installation. More blazing CPU action (stuck here for minutes).

Restart-computer

 

So this is how the 2017 installer was successfully installed and refreshed your system.

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!