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
1. Windows - It not required user id and password
2. SQL Server - It required user id and password
It complete depend upon installation time.
Application Path :
Start --> All Programs -->Microsoft SQL Server 2008 R2 --> SQL Server Management Studio
Step - 1
Open your database engine
Step - 2
Server Name define, which server is connect to SSMS.
Step -3
Authentication
1. Windows - It not required user id and password
2. SQL Server - It required user id and password
It complete depend upon installation time.
Application Path :
Start --> All Programs -->Microsoft SQL Server 2008 R2 --> SQL Server Management Studio
 Database Connection ){kind=link}