Skip to main content

Installing Microsoft Sql Server Step by Step

SQL Server Installation Guide



What is Sql Server?


SQL Server is a relational database management system, or RDBMS, developed, maintained and marketed by Microsoft.
It is used to store and retrieve data as requested by the user in a tabular form. The storing and retrieval and be done same system or over a computer network.

Downloading the system


Type Microsoft Sql Server download in url bar and select SQL Server Downloads | Microsoft
From the search results, or click here

Select either Developer or Express version and click download as shown below


Installation_imge




In this case, we are selecting Developer Edition for this tutorial, therefore click on Download now for Developer as shown below


Developer Edition


Select the installation type you want, in our case, we are selecting Basic, so click on Basic and accept the License Terms by clicking on Accept to continue


Developer Edition License


Specify the location you want to install the application and click on install button


Wait for the Application to download the time taken depends on your network speed
Sql Installer Progress

The installer will install planning section. Click on the Installation tab as shown below
SQL Planning

Select New SQL Server stand-alone installation or add features to an existing installation
New Instance Installation
In product key, you can specify a license or select a free edition. In this tutorial, we will install the developer edition.
SQL Product Key

Click on Next for License Terms to show the terms to install it. Accept the license terms
License
In Microsoft updates, you can verify if there are updates in the installer before proceeding
SQL Installer Update
The Install Rules will verify the Active Template Library, the registry keys and if the computer is not a domain controller, or any feature that will prevent the installation
Installer Rules
In the context of the Feature Selection, Select Data Engine Services, which is the database itself. You can also selection other features based on what u want to do. In this case, we are Ok with Data Engine and click on Next.
Feature Selection
You can have multiple SQL Server instances in SQL Server in the same server. This can be useful to simulate and practice replications, mirroring or to have separate instances for different purposes. By default, you can install the default instance that is usually the Server computer name, we are choosing default instance for this tutorial

Sql Instance

Set how the services start. It is a good practice to keep them. Do not grant administrative privileges to these accounts unless there is no other choice
Server Configuration
There are two options in SQL Server to authenticate. Windows authentication will use the Windows Account to authenticate in SQL. Mixed Mode allows creating internal logins and passwords inside SQL Server. You can Add accounts here using the Add Current User or by pressing the Add button as shown below
SQL Engine Config
Once that you have installed everything, you can verify the configurations. If everything is OK, press Install as shown below
SQL Installation Ready
After some minutes depending on your system speed, you will have your database installed
SQL Server Installation Complete
You have successfully installed Sql Server to your Computer System
Thank you
Labels:

Comments

Post a Comment

Popular posts from this blog

The String.Join Method in C# Explained

The String.Join Method in C#   The string.Join concatenates the elements of a specified array or the members of a collection, using the specified separator between each element or member. Overloads of string.Join Method Description Join(Char, Object[]) Concatenates the string representations of an array of objects, using the specified separator between each member. Join(Char, String[]) Concatenates an array of strings, using the specified separator between each member. Join(String, IEnumerable<String>) Concatenates the members of a constructed IEnumerable<T> collection of type String, using the specified separator between each member. Join(String, Object[]) Concatenates the elements of an object array, using the specified separator between each element. Join(String, String[]) Concatenates all the elements of a string array, usi...
Post a Comment
Read more

Most Popular Programming Languages in 2020

Most Popular Programming Languages in 2020 In this blog post, you will learn about the most popular programming languages in 2020 for creating the best web applications. Check its pros and cons. Analyzed by technostacks Not very long ago, just a few people were considered to be computer programmers, and the general public viewed them with awe. In this digital age that we are now living in, however, a large number of IT jobs need a solid grasp of one or more programming languages. Whether one wants to develop a mobile app or get a certification for having programming knowledge, or even to learn new skills, one needs to opt for the right programming language. Below mentioned eight most popular programming languages which are in demand for software development and web applications. This is the most used programming languages in 2019 and will be in 2020. For each, there is little information about the language, benefits and its complexity, as well as about its usage. One must...
1 comment
Read more

HashTable in C# with Example

  HashTable in C# with Example Hashtable  is used to store a collection of key/value pairs of different  data types  and are organized based on the hash code of the key.   Generally, the hashtable object will contain buckets to store elements of the collection. The bucket here, is a virtual subgroup of elements within the hashtable and each bucket is associated with a hash code, which is generated based on the key of an element.   In C#, hashtable is same as a  dictionary  object but the only difference is that the  dictionary  object is used to store a key-value pair of same  data type  elements.   When compared with  dictionary  object, the hashtable will provide a lower performance because the hashtable elements are of object type so the boxing and unboxing process will occur when we are storing or retrieving values from the hashtable.   C# HashTable Declaration Hashtable is a non-generic type...
Post a Comment
Read more