Using SSMS:

  • It’s a client tool used to connect to SQL Server.
  • It can be installed on any system.
  • Developer will connect to SQL Server using this.

 

Connect to local server:

 

  1. (local)
  2.  
  3. .
  4.  
  5. localhost
  6. IP Address (e.g. xxx.xx.xx.xx)
  7. System Name (e.g. MySQLServer)
  8. 127.0.0.1 Loop Back IP Address)

Connect To Local Server