Answered by:
Error during configuring distribution wizard

Question
-
TITLE: Configure Distribution Wizard
------------------------------An error occurred configuring SQL Server Agent.
------------------------------
ADDITIONAL INFORMATION:SQL Server blocked access to procedure 'dbo.sp_set_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. (Microsoft SQL Server, Error: 15281)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15281&LinkId=20476
------------------------------
How do I solve this??
Thanks,
Frank
System Engineer
Friday, June 30, 2006 11:11 PM
Answers
-
I think the solution is pretty clear inside the error message. Did you have problems following the instructions?Saturday, July 1, 2006 1:49 AM
-
SQL Server 2005 Express does not have a SQL Server agent. Nor can it be configured as a distributor.
Exactly how are you attempting to configure it as a distributor?
From http://msdn2.microsoft.com/en-us/library/ms151819.aspx
- SQL Server Express cannot serve as a Publisher or Distributor. However, merge replication allows changes to be replicated in both directions between a Publisher and Subscriber.
Tuesday, April 24, 2007 2:26 PMAnswerer
All replies
-
I think the solution is pretty clear inside the error message. Did you have problems following the instructions?Saturday, July 1, 2006 1:49 AM
-
The worst part, as with many of the error messages, the link in the error takes you to a "sorry no information is available about this problem". Don't know what broke in that process, but I have seen that exact page come up several times while checking alerts in MOM. I hope it is something that will be fixed soon because it seems pretty sad that a link in internal help provides "No Help".
Allen
Friday, September 8, 2006 6:38 PM -
Please execute
The following shows the available options
USE master;
GO
EXEC sp_configure 'show advanced option', '1';
RECONFIGURE;
EXEC sp_configure;
The following enables the Agent XPs
EXEC sp_configure 'Agent XPs', '1';- Proposed as answer by M. AMIR Wednesday, September 29, 2010 11:05 AM
Saturday, September 16, 2006 3:56 PM -
Hi,
Has anybody get the solution as I am getting the same error while installing sqlserver 2005 express on my window xp.
pls see below
TITLE: Microsoft SQL Server 2005 Setup
------------------------------SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot add functional unit 'sp_sqlagent_get_startup_info' to component 'Agent XPs'. This unit has been already registered with the component.. Refer to the server error logs and Setup logs for detailed error information.
------------------------------
BUTTONS:&Retry
Cancel
------------------------------Thanks
Sunday, April 22, 2007 7:58 AM -
SQL Server 2005 Express does not have a SQL Server agent. Nor can it be configured as a distributor.
Exactly how are you attempting to configure it as a distributor?
From http://msdn2.microsoft.com/en-us/library/ms151819.aspx
- SQL Server Express cannot serve as a Publisher or Distributor. However, merge replication allows changes to be replicated in both directions between a Publisher and Subscriber.
Tuesday, April 24, 2007 2:26 PMAnswerer -
try this :
Change the system date to cureent day
Monday, June 4, 2007 7:41 AM -
Thank you very much Sergijko !.. For me, that was the solution !Sunday, November 18, 2007 10:04 AM
-
This worked for me as well. Thank you very much!
Where did you find the solution? I was unable to find any information like that for this error until I found your post.
Thursday, December 13, 2007 6:44 PM -
Renjith’s solution worked for me however I was trying to change the services from running under Local System to a domain account. I had to change the services back to Local System, then run the code, and then I could change the services to run under a domain account.
Tuesday, January 29, 2008 7:31 PM -
Sunday, April 6, 2008 12:24 PM
-
***, this works for me. I just set the date to the right time and installation finished without problems. My hero :-)Tuesday, August 12, 2008 1:25 PM
-
Friday, November 28, 2008 5:34 AM
-
It works for me as well!
ThanksFriday, April 17, 2009 11:04 AM -
thank you very much!! solved for me as wellFriday, May 22, 2009 12:46 PM
-
Hi All, for what it is worth I was trying to install SQL Express and indeed my system clock was wrong now installed :) well done!Saturday, October 3, 2009 12:21 PM
-
try this :
Change the system date to cureent day
Great! Worked for me too (Old laptop lost the date & time)Tuesday, October 27, 2009 12:52 PM -
Thank u very much ... after changing system date to current date, it is workingThursday, November 12, 2009 9:20 AM
-
Hello sergijko,
This solution worked for me, Thanks a lot! :)
-GangadharWednesday, January 20, 2010 4:53 PM -
I have visited lots of website to fix it..finally you can follow the below instruction.I think it will help you..
There is a possibility for getting this error message due to incorrect
date/time settings.
What you can try is confirming that the date/time and time zone are set
correctly and if not, then set them up accordingly.i got this suggestion from this site...
Regards
Dreamkiller
Reference:http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-setup/9972/SQL-Server-Setup-failed-to-execute-a-command-for-server
Sunday, September 5, 2010 4:59 PM