Hi Stian,
This actually sounds like an adCenter Desktop Issue as the Ad Intelligence does not use SQL2008. The best thing to correct the issue is to ensure that you uninstall the any instance of SQL 2008 from your control panel and if there is an entry for the adCenter Desktop Tool (ACD) and remove it as well. Once you have verified that none of these are listed in your control panel, reboot your PC and then re-run the installer for the ACD.
Install Location: http://go.microsoft.com/fwlink/?LinkID=164973&clcid=0x409
Alternativly, you can install the prerequisits seperatly, then install the ACD. Below you will find the links for the files that are needed.
Windows Installer 4.5:
Windows 7 or Windows Vista and Windows Server 2008 on x86 platform
Download link: http://go.microsoft.com/fwlink/?LinkID=120238
Windows Vista, Windows Server 2008 RTM on IA64 platform
Download link: http://go.microsoft.com/fwlink/?LinkID=120240
Windows XP Service Pack 2 on x86 platform:
Download link: http://go.microsoft.com/fwlink/?LinkID=120234
Microsoft .Net Framework 3.5 SP1:
Download link: http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe
Microsoft SQL Server Express 2008 SP1:
On x86 platform
Download link: http://download.microsoft.com/download/8/E/5/8E53FAA8-1129-4621-903F-3F8DB6D066AC/SQLEXPR32_x86_ENU.exe
On x64 platform:
Download link: http://download.microsoft.com/download/8/E/5/8E53FAA8-1129-4621-903F-3F8DB6D066AC/SQLEXPR_x64_ENU.exe
Microsoft adCenter Desktop:
English location - Download link: https://maf.adcenter.microsoft.com/desktop/setup/en/adcenterdesktopinstaller.msi
French location - Download link: https://maf.adcenter.microsoft.com/desktop/setup/fr/adcenterdesktopinstaller.msi
Please ensure that you have met all the prerequesits prior to installation or you may receive similar errors. Note that all required software will automatically be installed if not present: Windows Installer 4.5, Microsoft SQL Server Express 2008 SP1, Microsoft .NET Framework 3.5 SP1
Thank you,
Brian H - MSFT