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)
  3. .
  5. localhost
  6. IP Address (e.g. xxx.xx.xx.xx)
  7. System Name (e.g. MySQLServer)
  8. Loop Back IP Address)

Connect To Local Server