SSMS (SQL Server Management Studio) Database Connection

June 30, 2015 0 Comments A+ a-

SQL Server Management Studio is the principal tool for administering the Database Engine and writing Transact-SQL code.
Step - 1
Open your database engine.
Step - 2
Server Name define, which server is connect to SSMS.
Step -3
Authentication

  • Windows - It not required user id and password
  • SQL Server - It required user id and password

Application Path 
Start --> All Programs -->Microsoft SQL Server 2008 R2 --> SQL Server Management Studio

Please follow the below screenshots for your reference.

SQL Server Management Studio

SQL Server Management Studio