I recently had to do this, and it was no fun at all. You have to download all the prerequisites, put them in a directory, and then run a long command with arguments. For simplicity’s sake, I have compiled everything you need.
This installation took place on a machine running Windows Server 2008 R2 (64-bit of course).
First, download this package and extract it to your C:\. Your file structure should look like C:\SPPR\<files>
Next, mount the installation disc on your server. For this example, I’m just going to say it is the D:\. Open a command prompt and run this command (all on one line):
D:\>PrerequisiteInstaller.exe /SQLNCli:C:\SPPR\sqlncli.msi /KB976462:C:\SPPR\KB76462.msu /IDFXR2:C:\SPPR\IDFXR2.msu /Sync:C:\SPPR\Sync.msi /ChartControl:C:\SPPR\ChartControl.exe /FilterPack:C:\SPPR\FilterPack.exe /ADOMD:C:\SPPR\ADOMD.msi
If you get installation errors, you may have to run the sqlncli.msi package. Be advised, this package was taken from a SQL 2008 R2 disc. After successfully installing sqlncli.msi, you can rerun the entire command again. It should come back OK.
There you have it, simple and effective and a heck of a lot less trouble than what I went through.