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

 

Answer 1

I think the solution is pretty clear inside the error message.  Did you have problems following the instructions?

Answer 2

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

Answer 3

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';

 

Answer 4

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.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40sysdbupg.sql%40107%40x3bff

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------

 

 

Thanks

Answer 5

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