Solved

sqlseverexpress 2008 agent xps question

Posted on 2016-11-16
1
25 Views
Last Modified: 2016-11-17
I have a server that is running sql express 2008.   the sql server agent is stopped and i am also reading that sql express doesn't have xp agent anyway (so why is it listed in services).  I am receiving a bunch of log file errors where it is advising me to turn on agent xps with an sp configure command.
any thoughts?  currently the app is throwing a bunch of errors and my event log is littered with the agent errors.


the exact language of the error is
sql server blocked access to procedure 'sys.zp_sqlagent_enum_jobs' of component 'agent xps' because this component is turned off as part of the security configuration for this server.  A system administrator can enable the use of 'agent xps' by using sp_configure
0
Comment
Question by:jamesmetcalf74
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41891324
SQL Server Express doesn't offer the SQL Agent service so you'll never be able to activate the 'agent xps'.
If you want this to work you'll need to upgrade to SQL Server Standard Edition. Mind that's not free.
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question