SSMS (SQL Server Management Studio) Database Connection

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.