DBAs and Developers are normally using
below steps to connect to SQL Server Management Studio.
1. Start ---- All Programs ---- Microsoft SQL Server 2012 ---- SQL Server
Management Studio.
2. Then Choose Windows Authentication
or SQL Server Authentication.
3. Provide User Name and Password and
Click Connect.
It can be optimized by using command
line parameters.
Let’s type below command to
understand the list of parameters available.
>> ssms /?
Below command is used to connect to
SQL Server Management Studio using Windows Authentication. –E parameter is used
to connect to SQL Server through Windows Authentication.
>> ssms –E
Below command is used to connect to
SQL Server Management Studio using SQL Server Authentication. It is connecting
to [BYGQVS1-TEST] SQL Server Instance.-U indicates Username. –P indicates
Password.
>> ssms –S BYGQVS1-TEST –U sa –P
welcome@123
No comments:
Post a Comment