My system is Windows 7, install the SQL SERVER 2012 version, downloaded from the website, but at startup: SQL SERVER agent (MRWXK) (network service) and SQL SERVER agent (SQLEXPRESS) (local) tip: when the SQL SERCER agents on the local computer (SQLEXPRESS) service start after stop, brother please help have a look at what's going on, never on the Internet search the answer to a solution,

CodePudding user response:

Look at the Windows log content

CodePudding user response:

To install, no warning system log,

CodePudding user response:

reference 1st floor sinat_28984567 response:

look at the Windows logs have any content

-- -- -- -- -- -- -- -- -- -- today's computer to start with the following warning logs: 1. Due to the following error, ComputerZLock service startup failure:
System cannot find the specified path, source: the Service Control Manager. 2. SQL Active Directory Helper Service Service for specific error % % - 1073741724 Service stopped, source: the Service Control Manager.

CodePudding user response:

In two solutions:

A. Solve 'MSDB' architecture 'dbo') the EXECUTE permissions permission problems:
Found in SQL Server Management Studio 'MSDB, database into properties, permissions, user or a role below corresponds to the execution of the check in the bottom up,


2. Solve the problem of SQL server has been terminated:

Open the registry CMD enter regedit,
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server \ MSSQL11 SQL2012 \ SQL \ ServerHost in this location to find ServerHost

Double-click to open ServerHOST properties, under the "value data" fill in the name of the computer as my DESKTOP - CH4POFJ

CodePudding user response:

I can't connect the server now, how do I find the database

CodePudding user response:

Grave post also dug up 3 years ago, probably knot posted rate 0% of the original poster can't remember it,

However, still stick the correct answer, that is always someone to dig this

Express version without the SQL agent service, don't use the official version must be installed to SQL agent service this stuff,