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.