Steps wise instruction with screenshot how to install SQL Server with Management Studio (SSMS) to interact with SQL server instance.
The SQL Server Management Studio is a software or interface which use for querying, designing and managing SQL Server on your local computer or in the cloud. It provides you with tools to configure, monitor and administer Server instances.
SSMS is the interface which you can use to work with remotely setup SQL server. For remotely SQL server you need exact domain name or IP address to link with that server.
SSMS can be used to perform almost all task and query which can be performed on SQL server. as mentioned below, these all query can be performed using SSMS
- SQL can execute queries and get result from a database
- SQL can retrieve data
- SQL can update records
- SQL can insert records
- SQL can delete records from a database
- SQL can create new databases
- SQL can create new tables in a database
- SQL can create stored procedures
- SQL can create views
- SQL can set permissions on tables and views
- SQL can get result like pivot using Group by command
You will learn below point
- How to Download SQL Server Management Studio
- How to Install SQL Server Management Studio
- Overview of Management Studio
- How to access “SQL Server with Management Studio”
How to Download SQL Server Management Studio
Download the SSMS from the Microsoft website via the below link and follow the below installation steps to install Management Studio.
Download SQL Server Management Studio
How to Install SQL Server Management Studio
Step #1:
Double-click the setup file SSMS-Setup-ENU.exe to start installing. The installation process of SMSS is very simple, just need to follow the below screen sequence.
Step #2:
Click the Install button
Step #3:
It will show the progress
Step #4:
After successfully installation it will show below screen
Now, Both (SQL server and SSMS) are installed on your system/Computer.
Next, you should learn how to connect to the SQL Server with Management Studio. And practice all commands from this tutorial. We will provide you the sample/Practice data as well for you.
Overview of Management Studio
Let try to understand different area of Management Studio window. As shown below image the numbering and each numbers are explained in the below.
- This is the main Manu of the SSMS where you can see many options
- This is important window which shows the current database which you are using, creating Table and performing queries.
- Click to get new window for Query/Command space.
- Click to execute the query. If you will click on execute it will run all written queries in the query window. If you want to run specific query you can select that specific line or portion of query and then click on Execute button to run it.
- this is the window/space where you can write your queries and SQL commands.
- This is the navigation for all database and Tables which you have created within the Database. Sometimes you need to refresh table from navigation bar, if data is not reflecting after query run. (select table > right click > click on refresh table button)
- this is the Messages area where it will show your successful or error command messages.
These are the very basic options in Management studio, which you will use mostly during your day to day SQL command.
How to access “SQL Server with Management Studio”
After the installation of Management studio you have to follow below steps to access the SQL server with management studio.
Step #1:
Search management studio in start menu and in search option of start menu, click on Management studio, as you see in image below list.
Step #2:
- Once you will click, it will ask you to select Server type and Server name.
- Server Type= “Database Engine”
- Server name = click on “Browse for More …” Option,
- It will show another window and from that window from option “Database Engine” , select your machine name as Server name (as marked as 3 in below screenshot).
Step #3:
Now next step to enter username or Password and you can also use window Authentication as well
Step #4:
- Once you will get connected to SQL server via Management Studio you will se below screen with Object
- Object Explorer is the navigation bar which show you your Database, Table and Views. learn How you can create database from Management Studio.
Management studio is very powerful instant which you can use to connect with SQL server and also Microsoft Azur Server easily. and almost all SQL query and task you can perform. you can learn more about SQL – Data Manipulation command s which can be helpful to enhance your skills.
Let’s understand important fields appear in server connect window
Server type: Four type of option MS SQL services available and we will be working on ‘Database Engine’ for creating and working with Database. Other Server type includes Analysis, Reporting & Integration Services.
Server name: It is a server’s name where MS SQL Server is installed and need to establish the connection with that server. Generally, we use the server name as “Machine name\Instance.” Here Instance is the name given to SQL Server instance.
Authentication: This is defaulted to “Windows Authentication” if we use “Windows Authentication” during SQL Server Installation. (prefer window authentication would be good to avoid remember multiple password)
Login (as User name)\Password: If Authentication is selected other than “Windows Authentication” like “SQL server Installation” then these two fields will be required.
Click on ‘Connect.’ Now you will be connected to ‘Data Management Studio.’