How to Connect to SQL Server Default Instance and SQL Server Named Instances - SQL Server / TSQL Tutorial Part 2

Scenario:

We have installed SQL Server Management Studio successfully on our local machine. How can we connect to Default SQL Server Instance or Named SQL Server Instance from SQL Server Management Studio( SSMS)?


Solution:

There are multiple ways you can connect to Default SQL Server Instance by using SSMS. Here are three ways

By using (Local)
Open SSMS and then type (local), if there would be local SQL Server Instance on your machine, it will connect to it.

How to connect to Default SQL Server Instance by using (local) Key word - SQL Server Tutorial




By using Dot (.)
You can simply put Dot (.) and connect to your default SQL Server Instance as shown below.
Connect to Default SQL Server Instance by using Dot(.) - SQL Server Tutorial

By using Loop Back IP ( 127.0.0.1)
You can use loop back IP to connect to your Default SQL Server Instance Name.

Use Loop Back Ip Address to connect to Default SQL Server Instance from SSMS 



How to Connect to Named SQL Server Instance from SSMS
To connect to Named SQL Server Instance from SSMS, you have to provide Machine Name\SQL Server Instance Name.

Let's say if your computer Name is AamirPC and you have Installed Named SQL Server Instance "SQLServer2016". To connect to SQL Server Instance , you will be typing AamirPC\SQLServer2016.


How to connect to Named SQL Server Instance by using SSMS - SQL Server Tutorial