You can see Object explorer on the left hand side (LHS ) of the SQL Server Management Studio and on your right hand side (RHS), a blank area that we usually use for SQL query. Once you login the SQL Server you can see the default environment of the SQL Server Management Studio.
But, in case of windows authentication, you DO NOT need login and password details, however you need to give sufficient access rights to windows login to connect to SQL Server. However, for the best practice you must enter the Server name, Login & password for SQL Server Authentication. If you would like to connect locally installed SQL server, you can place a dot instead of Server name and it will connect to that server. Provide the credential of SQL Server which you intend to connect. Again select Start > All Programs > Microsoft SQL Server 2012 > SQL Server Management Studio. Step 3 – Start SQL Server Management Studio:
Ensure service status has been changed to Start mode. If not, start this service by selecting the service, right click and start. In this step, check if SQL Server service is running or not. Once you are inside SQL Server Configuration Manager tool, you can see a lot of services in multiple states (start, pause, running). SQL Server Configuration Manager is a user friendly tool to manage the services related to SQL Server. Go to Start > All Programs > Microsoft SQL Server 2012 > Configuration Tools > SQL Server Configuration Manager. Step 1 – Open SQL Server Configuration Manager: Let me demonstrate how to configure SQL Server Management Studio (SSMS) in seven easy steps. You will also learn the best / most efficient way to find the right feature at the right place at the right time, because this is one of the biggest challenges for a newbie. In addition, I will walk you through the multiple settings of SQL Server Management Studio configuration, which can help you build a conducive environment and prevent frequent configurations. In this tutorial, I shall demonstrate the configuration of SQL Server Management Studio to reap the best of it as well as to make the work quite simple. In my earlier tutorial, I explained how to install SQL Server Management Studio in few easy steps. In the case of SQL Server Management Studio (SSMS), it is configured by default with the standard settings, and it can be further configured to make the work easier. However, some applications are configured at the time of installation (with default settings) while in other cases, manual configuration is done to achieve its real benefits. Configuration of the application plays a significant role in any application, when installed.
0 kommentar(er)
