Shulou(Shulou.com)05/31 Report--

This article mainly explains the "SQL Server agent service can not start how to solve", the article explains the content is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "SQL Server agent service can not start how to solve" it!

Error message: error MSSQLSERVERSQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but "(unknown)" is not a member of the SysAdmin role).

Running environment: Windows2003R2 32bit + MSSQL2005+ enable SQL AWE memory management reason: lower the right to SQL to run after the Network Service permission.

Solution: open Group Policy\ computer configuration\ Windows Settings\ Security Settings\ Local Policy\ user Rights assignment\ Lock the page in memory and add an account running SQLAgent

Thank you for your reading, the above is the "SQL Server proxy service can not start how to solve" content, after the study of this article, I believe you can not start the SQL Server proxy service how to solve this problem have a deeper understanding, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.