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

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

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

(or)

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

(or)

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

(or)

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...

Regards
Akiii

Login to post response