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



5 comments:

  1. How to connect to sql server when you have ssms version which is released in 2020 and after installing ssms you are not getting configuration manager settings

    ReplyDelete
  2. These proxy websites are simply called as proxies. Proxy server is an intermediate server, which handles data sharing between a client and a server.why you should always use a vpn reddit

    ReplyDelete
  3. It didn't take long for the principal threats toward start a couple of years after the fact in 1891 over, for goodness' sake, the school tones. UGA's school magazine pronounced the school tones to be gold, dark and ruby. Georgia's football trainer felt that gold was excessively near yellow, which he felt symboled weakness. download free vpn

    ReplyDelete
  4. i read a lot of stuff and i found that the way of writing to clearifing that exactly want to say was very good so i am impressed and ilike to come again in future.. how to block subreddit on Reddit

    ReplyDelete
  5. I read that Post and got it fine and informative. https://www.sorrisieservizi.it/

    ReplyDelete