How to start the SQL server

How to start the SQL server

Microsoft SQL Server is the finished solution for management and data analysis allowing to deploy quickly scalable Web applications of new generation. SQL Server - the key component of support of electronic commerce, interactive business applications and data storages providing the scalability necessary for support of the growing, dynamic environments. For operability of MS of SQL Server SQL Server and SQL Server Agent services should be started.

Instruction

1. Start of SQL Server service internal means of Microsoft SQL ServerBo installation time of Microsoft SQL Server, install such SQL Server component as Service Manager. Which allows to stop, suspend, start SQL Server. To open the SQL Server Service Manager window it is necessary to open the list of the installed programs, having pressed the Start button, then Programs. In the opened list of the installed programs it is necessary to select Microsoft SQL Server, then in to select Service Manager. In the opened SQL Server Service Manager window in the field of Server the name of the current server, in the field of Services the name of MS service of SQL Server is displayed. Besides, in a window buttons of start (Start), suspension (Pause), a stop (Stop) of MS services of SQL Server are located: SQL Server, SQL Server Agent. For start, suspension, a stop of SQL Server it is necessary to press the button Start, Pause, Stop respectively.

2. By means of a command strokikomanda of Net Start and Net Stop MSSQLServer, MS services of SQL Server from the command line allow to start and stop start of SQL Server service. For this purpose it is necessary to press the Start-up button (Start) and to select the Run clause. In the opened window to make the cmd team and to click OK. At the same time the window of the command line will open. For start of service by means of the command line, it is necessary to make the Net Start MSSQLServer team in the appeared window of the command line and to click the keyboard ENTER key. Then it is necessary to wait for the message in the command line about successful start of SQL Server.

3. Start of SQL Server service with use of a window of services of a serveran a desktop the right mouse button to select a label "My computer" (My Computer). In a context menu to select the Manage item. In the right part of the opened Computer Management window left click to open the Services and Application menu and to select item of "Service" (Services). In the right part of the Computer Management window there will be a list of all services installed on this server. The right mouse button it is necessary to select MSSQLSERVER service from the appeared list and in the appeared menu to select the Start item. In the Status column the current status of services is displayed. The SQLSERVERAGENT service is started by a similar way.

Author: «MirrorInfo» Dream Team


Print