Скачать или смотреть How to Connect to SQL Server Default & Named SQL Server Instances from SSMS - SQL Tutorial Part 2

How to Connect to SQL Server Default & Named SQL Server Instances from SSMS - SQL Server / T-SQL Tutorial

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.


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

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


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.

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
http://www.techbrothersit.com/