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

Classes in C# Explained

C# Class Explained A class is nothing but an encapsulation of properties and methods that are used to represent a real-time entity, as explained by Guru99 . For instance, if you want to work with Guest’s data as in our previous DataDriven Web application . The properties of the Guest would be the Id, GuestName, Address, Phone number etc of the Guest. The methods would include the entry and modification of Guest data. All of these operations can be represented as a class in C# as shown below. using System; namespace CsharpnaijaClassTutorial {     public class Guest     {         public int Id { get ; set ; }         public string GuestName { get ; set ; }         public string Address { get ; set ; }         public string WhomToSee { get ; set ; }     ...
1 comment
Read more

ASP.NET MVC Views

Views in ASP.NET MVC Application explained Find a related article By  Steve Smith  and  Luke Latham from Microsoft Corporation here In the Model-View-Controller (MVC) pattern, the  view  handles the application's data presentation and user interaction. A view is an HTML template with embedded  Razor markup . Razor markup is code that interacts with HTML markup to produce a webpage that's sent to the client. In ASP.NET MVC, views are  .cshtml  files that use the  C# programming language  in Razor markup. Usually, view files are grouped into folders named for each of the application's  controllers . The folders are stored in a  Views  folder at the root of the application as shown: The  Home  controller is represented by a  Home  folder inside the  Views  folder.  The  Home  folder contains the views for the  About ,  Contact , and  Index...
Post a Comment
Read more

ASP.NET MVC Routing

ASP.NET MVC Routing ASP.NET MVC routing is a pattern matching system that is responsible for mapping incoming browser requests to specified MVC controller actions. When the ASP.NET MVC application launches then the application registers one or more patterns with the framework's route table to tell the routing engine what to do with any requests that matches those patterns. When the routing engine receives a request at runtime, it matches that request's URL against the URL patterns registered with it and gives the response according to a pattern match. Routing pattern is as follows A URL is requested from a browser, the URL is parsed (that is, break into controller and action), the parsed URL is compared to registered route pattern in the framework’s route table, if a route is found, its process and send response to the browser with the required response, otherwise, the HTTP 404 error is send to the browser. Route Properties ASP.NET MVC routes are res...
Post a Comment
Read more