Solved

sqlseverexpress 2008 agent xps question

Posted on 2016-11-16
1
24 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 48

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
space used inside SQL data file- PerfMon counter.. 2 28
sql 2014,  lock limit 5 37
Parse this column 6 27
SSIS Standard Template for Reuse by Business Units 12 8
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

820 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