What are all the ways to connecting Locally on the Server ?

 Posted by PandianS on 5/28/2011 | Category: Sql Server Interview questions | Views: 4295 | Points: 40

Important: The Server and Client machine are the same machine

If the Server Name : SQLFunda
If the Instance Name : SQLBuddy

When we try to connect with the SQL Server from the Client, we can use either one of the ways...

1. Server Name\Instance Name
i.e: SQLFunda\SQLBuddy


2. (Local)\Instance Name
i.e: (Local)\SQLBuddy


3. Localhost\Instance Name
i.e: Localhost\SQLBuddy


4. .\Instance Name
i.e: .\SQLBuddy

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Akiii on: 5/30/2011 | Points: 10
good one...


Login to post response