Solved

sqlseverexpress 2008 agent xps question

Posted on 2016-11-16
1
23 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 47

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

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.
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

810 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