Adventures of setting up MOSS on Windows 2008 – Part 1

I have been installing MOSS on a Virtual Machine with Windows 2008 RTM. A colleague (David Marsh) is setting up the 64 bit version and I am trying the 32 bit version so we can compare if there is a noticeable difference in performance.

I have come up against a few issues while doing the installation which I thought I would share.

SQL 2005 Reporting Services

I had some difficulty configuring reporting services. I installed SQL 2005 Standard with SP2.

I went through the normal configuration and everything looked ok.

When I tried to access the ReportServer or Reports from the browser however, I received these errors;

(rsAccessDeniedToSecureData)

I checked the rsreportserverconfig to make sure the URLRool and WebServiceAccount were correctly configured.

After much effort trying to work out what was causing the problem, I decided to create a new database and remove the old one. This fixed the issue, so I can only imagine that there were some permission issues with database access.