MSSQL

How to install Microsoft SQL Express Edition Server On your local Machine

male avatar

taher

Published On : 2022-03-14
blog header

SQL (Structured Query Language) is Language used to maintain and Save data Efficiently. It Relational Data Management system mainly developed on SETS concept in mathematics . Microsoft SQL Server is a SQL Server of Microsoft company . It is highly Efficient and Secure Server by Microsoft .

It has different Edition of product for use

Express Edition

it is Students and small developer with no charges (Limitation only 10 GB of data you will be able to store . Many features are not there)

Enterprise Edition

It is Paid version by microsoft. SQL Server Enterprise Edition includes both the core database engine and add-on services, with a range of tools for creating and managing a SQL Server cluster. It can manage databases as large as 524 petabytes and address 12 TB of memory and supports 640 logical processors (CPU cores).

It has many different versions also to know more about it you can visit wikipedia.com. It is here

Requirement

  1. MSSQL Server by microsoft
  2. Microsoft SQL Server Management Studio ( For Managing different SQL Server of it )

Steps to setup Microsoft Structured Query Language (MSSQL) Express Edition

  1. Download MS SQL Server Express Edition from here . we will downloading and installing MSSQL 2008 r2 Express Edition.
  2. Just run Downloaded file and install it
  3. Now download microsoft sql server management studio from here. We are usign MSSQL management studio 2008 for learning purpose
  4. Download Version According to your machine.
  5. Install itF

Following Video Demonstrate Screens after download and install Process of MSSQL Server Express Edition

 

Install and Download SQL server Management Studio

  1. Following Video Demonstrate to do it .
  2. To Connect to your SQL Express edition instances you need to type ./SQLExpress in server name and make sure you have given authentication as Windows Authentications . Then Click Connect




Leave a comment

Comments

No Comments Yet

About Us

We are Saify technologies a software development company located in india . Who develops custom Web , Mobile applications. We are specialized in Artificial intelligence technology. We have completed many projects on ecommerce with many different technology stacks which includes JAVA, Flutter , PHP, Python , C#,Swift and many more