Post reply

SQL Server Express 2014 Agent does not start on Windows 10 Home

  • November 15, 2015 at 8:37 am

    #399326

    I have installed SQL Server Express 2014 on my Windows 10 Home computer. The agent fails to come up with this error message: The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] (Error 229). I am not sure want I need to grant or otherwise do for the agent to come up.

  • November 15, 2015 at 2:01 pm

    #1839858

    SQL Express does not include the SQL Agent. it does nto get installed, and that's the reason for the error.

    if you need agent, you need either the developer edition(~50 USD on amazon) or a real instance like Standard or above.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply