SQL Server Management Studio
In this article we are going to know about SQL Server Management Studio and SQL Server Service
SQL Server Management Studio (SSMS) is a software launched with Microsoft SQL Server 2005. It is used for configuring, managing and administering all components with Microsoft SQL Server. SQL Server Management Studio is an integrated environment used for SQL infrastructure.
SQL Server management Studio also called as SSMS, SSMS is free It can be installed with Windows and it allow to connect and manage MSSSQLServer
Using Below link you download and install SSMS:
SQL Server Management Studio provides an user interface to interact with the database developer.
The Second thing is SQL Server Service.
SQL Server Service is a background process that internally connected with the SSMS.
How to Start and Stop the SQL Server Service:
First, we want to Go in our Control Panel, in that Control Panel the Administrative Tools option. Click on that. Next thing is find Services option and click on the option.
In Services, SQL Server (MSSQLSERVER) is our SQL Server Service. We can right click on that and Start or Stop the service.
If our Service is Stop we can not connect to management studio, If Service is stop right click on that and just Start the Service.
If you have to know more about SQL Server Service, You try to Connect to Server but it Cannot connect and How to know Start and Stop it visit to below link:
In this article we know about SQL Server Management Studio and SQL Server Service.
Thank for reading this article.
