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

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