Friday, February 01, 2013

SQL Server Agent (Agent XPs disabled)

Error in SQL Server Jobs:
SQL Server blocked access to procedure 'dbo.sp_get_sqlagent_properties' 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. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online.

Resolve by:
sp_configure 'show advanced options', 1; GO;
RECONFIGURE; GO;
sp_configure 'Agent XPs', 0; GO;
RECONFIGURE; GO;

17 comments:

Anonymous said...

Hi there! Do you know if they make any
plugins to help with Search Engine Optimization? I'm trying to get my
blog to rank for some targeted keywords but I'm not seeing very good
success. If you know of any please share. Kudos!

my web-site: please visit My site

Anonymous said...

I'm not sure where you are getting your information, but great topic. I needs to spend some time learning much more or understanding more. Thanks for excellent information I was looking for this info for my mission.

Here is my web blog :: acheter des followers

Anonymous said...

Hello there! I could have sworn I've visited this website before but after looking at some of the articles I realized it's new to me.
Anyways, I'm definitely happy I found it and I'll be bookmarking
it and checking back often!

Feel free to surf to my web-site ... プラダ トートバッグ

Anonymous said...

Useful info. Fortunate me I found your website by chance, and I'm stunned why this twist of fate didn't happened in advance!
I bookmarked it.

My web page; ロレックスレプリカ

Anonymous said...

We stumbled over here coming from a different page and thought
I should check things out. I like what I see so i am just following you.
Look forward to looking into your web page again.

Also visit my site ロレックスレプリカ

Anonymous said...

Do you have a spam problem on this website; I also am a blogger,
and I was curious about your situation; we have created some nice practices and we are looking to trade strategies
with others, why not shoot me an e-mail if interested.

Also visit my web page :: ロレックスコピー

Anonymous said...

Hi colleagues, how is all, and what you desire to say concerning this paragraph, in my
view its in fact amazing in support of me.

Also visit my web page; プラダ アウトレット

Anonymous said...

This is a really good tip especially to those fresh to the
blogosphere. Simple but very precise information… Thank you for
sharing this one. A must read article!

Review my homepage: rolexコピー

Anonymous said...

Awesome issues here. I'm very happy to look your post. Thank you so much and I am looking forward to contact you. Will you kindly drop me a e-mail?

Also visit my web blog - tux.ugr.es

Anonymous said...

Fabulous, what a website it is! This website gives
valuable data to us, keep it up.

my blog: gencoeservice.com.br

Anonymous said...

Definitely believe that which you stated. Your favorite justification appeared to
be on the net the simplest thing to be aware of.
I say to you, I definitely get irked while people consider worries that they
plainly don't know about. You managed to hit the nail upon the top and defined out the whole thing without having side effect , people could take a signal. Will probably be back to get more. Thanks

My site コーチ アウトレット

Anonymous said...

Very good info. Lucky me I came across your website by accident (stumbleupon).

I have saved as a favorite for later!

My blog post :: www.airjordanshoesoutletssale.com

Anonymous said...

Hello my friend! I want to say that this article is amazing,
nice written and come with approximately all vital infos.
I'd like to see more posts like this .

My blog post ... http://www.pradahandbagsoutletssale.com

Anonymous said...

Greetings from Idaho! I'm bored to tears at work so I decided to browse your website on my iphone during lunch break. I love the information you present here and can't wait to take a look when I get home.
I'm surprised at how fast your blog loaded on my phone .. I'm not
even using WIFI, just 3G .. Anyways, wonderful blog!


Also visit my page ... アバクロ通販

Anonymous said...

Hello, Neat post. There is an issue along with your web site in internet explorer,
might test this? IE still is the market chief and a huge
component of folks will miss your fantastic writing because of this problem.


My blog :: エアジョーダンスニーカー

Anonymous said...

My spouse and I stumbled over here coming from a different website
and thought I should check things out. I like what I see so i am just following
you. Look forward to finding out about your web page for a second time.



My blog ... www.monsterbeatsheadphoneoutletsale.com

Anonymous said...

I create a comment whenever I especially enjoy a article on a website or I have something to valuable to contribute to the conversation.
Usually it's a result of the fire displayed in the post I looked at. And on this article "SQL Server Agent (Agent XPs disabled)". I was moved enough to drop a leave a responsea response ;-) I do have a couple of questions for you if you don't mind.
Could it be simply me or do a few of the comments come
across like coming from brain dead people? :-P And,
if you are posting on other social sites, I would like to follow you.
Could you make a list every one of your community sites like your linkedin
profile, Facebook page or twitter feed?

Look into my weblog: クロエバッグ

Share Links