Agent XPs component is turned off

In Microsoft SQL Server Management Studio you get the following errors when trying to create a management plan either through the “Maintenance Plan Wizard” or the “New Maintenance Plan…” on an SQL Server 2008.

Cannot show requested dialog. Additional information: unable to execute requested command. ‘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.

To fix this right click on the server and select “New Query” as shown.

In the query window on the right type the following:

sp_configure ‘show advanced options’, 1;

GO

RECONFIGURE;

GO

sp_configure ‘Agent XPs’, 1;

GO

RECONFIGURE

GO

Then click Execute as shown.

Find Mysql Version on Windows

To find the version of MYSql you are using on a windows machine (i assume it is the same on a linux box) Open up a command prompt type the following : mysql -u root -p

You will then be prompted for your mysql password.

Now type: status

Office Sharepoint Server 2007 Blocked due to compatibility issues

When trying to install Office Sharepoint Server 2007 onto Windows 2008 R2 x64 you get the following error dialogue:

This program is blocked due to compatibility issues.

Program: Office Sharepoint Server 2007 – Please read Microsoft Knowledge Base article: 962935

Unfortunatly a quick search of the Microsoft site doesn’t yield this KB. If someone can find it please let me know and I’ll put a footnote to this post.

To fix this you are going to have to slipstream the Office Sharepoint Server 2007 SP2 into the CD or install files you are using.

1. Copy the Sharepoint CD to a folder on the Computer.

2. Download the releavant Service Pack 2 for the architecture you are using (64 bit in this case) from: http://www.microsoft.com/downloads/details.aspx?FamilyID=b7816d90-5fc6-4347-89b0-a80deb27a082&displaylang=en

3. Open a command prompt to the folder with the Service Pack 2 in it and type in the command: officeserver2007sp2-kb953334-x64-fullfile-en-us.exe /extract:c:\users\Administrator\Desktop\Sharepoint\x64\Updates

The path you extract to will most likly different depending on where you extracted the CD.

Note: According to http://technet.microsoft.com/en-us/library/cc261890.aspx you are supposed to delete a dll called Wsssetup.dll but I didn’t have this file in my updates folder or any other folder within the CD source so I ignored this step.

From here you should now be able to run the setup.exe from the root of your installation folder.