Windows can't start SQL Server (MSSQLSERVER) service (on the local computer erro

Recommended for you: Get network issues from WhatsUp Gold. Not end users.



Windows can't start SQL Server (MSSQLSERVER) service (on the local computer). Error 1069 the login failed and cannot start





1, The SQL service is started
2, Check the account password is correct
3, Whether there is a corresponding access account
4, Check whether the normal local SQL port monitor

-------------------------------------------------------------------------------------------

1, Open the "service", to find the SQL Server (MSSQLSERVER) service (corresponding to set examples or service), to view the properties, in the "landing" tab is selected in the "local system account".


2, For insurance purposes, this step operation: open the SQL Server Configuration Manager (SQL Server configuration manager), in the SQL Server Service (SQL Server service) to find the corresponding instance (name and "services" of the same). In the "landing" tab is selected in the "built-in account", and select "Local System" (the others such as NETWORK SERVICE can also, but to ensure that the authority).


3, Start the SQL Server service (MSSQLSERVER).


4, If you still go wrong (such as 126 error), then enter the SQL Server installation directory, to the installation directory NETWORK SERVICE distribution and the current logged on user permissions, especially the instance directory, as well as the database file directory write access, distribution. After the completion of service to start again.

-------------------------------------------------------------------------------------------

Reason:


γ€€γ€€360 anti-virus software, anti-virus put D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn the files in the directory to delete the part. Cause SQL Server (MSSQLSERVER) service will not start.



Solve:


γ€€γ€€The D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn copy directory covering the OK in other machine.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Bernard at October 02, 2014 - 10:56 AM