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 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

Role-Based Authorization in ASP.NET MVC

Role-Based Authorization Explained The most challenge aspect of any web application is implementing its security. In traditional web development with ASP.NET (from version 2.0 onwards), we have been using Membership and Role providers. These providers allows us to define Roles, Users and assign roles to users which helps us to manage Authorization. But with an increase in social networking and global authentication providers, we needed an upgraded membership system. ASP.NET Identity is the new membership system for building ASP.NET web applications, phone, store, or hybrid applications using social identities for authentication and authorization. So we can now use Windows Live (e.g. Hotmail), Gmail, Facebook and Twitter for authentication before the user starts using our web application. For internal application, we need to create users and roles for providing users access to creating items, products or managing other users. Necessary references are provided by MVC 5 applicatio...
1 comment
Read more