How to Install Microsoft SQL Server 2016


Among fresher's and developer, Installation of SQL Server is considered as complex task. This can become easiest if you follow instructions carefully
 



I am going to install MS SQL server 2016 Express edition with service pack 1 as its freely available


  2. I have downloaded file "SQLServer2016-SSEI-Expr.exe"  

  3. Now right click on file, run as administrator, Select basic


4. Scroll and accept license

5. Select installation location and click install, I am using default location

6. This will download original software and install


7. instance name is SQLEXPESS


No we will go ahead and install SSMS (This is required, If you want to connect to sql server and run some sql queries)


1. Click on Install SSMS button in above screen
His will take you on another scree to download files for SSMS (Sql server management studio)


2. Once Sql server is downloaded, you can open folder and start installation



3. Click install to install SSMS





4. Once SSMS installed, Restart your machine



5. After SQL Server restart you can go to start menu or desktop and search for SQL Server management studio





6. Type servername : yourmachinename\SQLexpress, if you are not aware of your machine name , right click on my computer and check properties



7. Once you are connect , Press ctrl +N à New Query window and type below code to create database dummy and enter few records in same.

Create database dummy
go
use dummy
Go
Create table emp(id int, name varchar(30), age int)
go
insert into emp values (1, 'saurabh', 30)
go
insert into emp values (2, 'vinod', 31)
go
select * from emp





2 comments:

  1. Dot Net Framework is the software framework developed by Microsoft Corporation. A programming infrastructure created by Microsoft for building, deploying, running applications and services use of Learn .net technologies such as desktop applications and web services. Dot Net Training in Chennai

    ReplyDelete