Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sqlseverexpress 2008 agent xps question

Posted on 2016-11-16
1
Medium Priority
?
30 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
1 Comment
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline

916 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