Renabling maintenance plans on SQL Server 2005 and 2008

Problem:
'Agent XPs' 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. (ObjectExplorer)

Fix:
1. Execute the following procedure in master Database

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO

Error when using Link Server

The execute permission was denied on the object ‘xp_prop_oledb_provider’

Fix::
GRANT EXECUTE ON xp_prop_oledb_provider TO [UserDomain\Account Name];

setupadmin and sysadmin should have in server role for the UserDomain\Account Name user.