SQL Server cannot be started.

Source: Internet
Author: User
Tags mssqlserver

SQL Server cannot be started.

The main reason why SQL Server cannot be started is logon. Here is a tips to solve the problem that SQL Server cannot be started. If you have encountered the problem that SQL Server cannot be started, take a look.

SQLServer sometimes cannot be started correctly because the Executive Service cannot log on. One of themMain reasonsThat is, LocalSystemAccount and AdministratorGroup cannot completely control two registry items.

1) Open the "Start" menu and select "run ". Click the Browse button to start browsing until the root directory of Windows2000 (usually WINNT) is found. Enter the systemdirectory and find regedt32.exe. Select it in the dialog box.
Click OK. The Registry Editor is started to display all configuration units in different stacked subwindows.
.

2) Select the "window" menu item HKEY_LOCAL_MACHINE. Its subwindows are displayed. Maximize the window for ease of use.

3) use the tree control in the left window to locate the SOFTWARE \ Microsoft \ MSSQLServer \ SQLExecutive subitem. Click this subitem to select it. Its value is displayed in the right window.
Go to SYSTEM \ CurrentControlSet \ Services \ SQLExecutive. Click this subitem to select it. Its value is displayed in the right window. Make sure that LocalSystemAccount and AdministratorGroup have full control over the item and Its subitem. The SYSTEM \ CurrentControlSet \ Services \ MSSQLServer \ SQLExecutive subitem must be checked again.
 
SQLServer has several levels of task failures, including some failed tasks and all failed tasks. In the latter case, when a common problem occurs, the registry entry conflicts with the use of a famous Pipeline.

Go to SOFTWARE \ Microsoft \ MSSQLServer \ SQLExecutive. Click this subitem to select it. Its value is displayed in the right window. Locate the ServerHost entry. Use the string editor to change its value so that it does not include the server name (only the famous pipeline to be used ).

These are the solutions that SQL Server cannot be started. I hope they will help you with your learning.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.