Sharepoint and SSRS Native Integration - Not seeing web parts after cabinet file install

I followed the steps here to set up Sharepoint integration with reporting services (SSRS) using native mode. (i.e., get a report explorer and viewer web parts)

However after adding the cabinet file e.g.,

STSADM.EXE -o addwppack -filename "C:\ Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall

I still don't see report explorer in the web parts list. Do you guys have any ideas? I'm very stuck and confused :-( Let me know if additional information would be helpful.

Update

There was an error message, any idea what it means?

Object reference not set to an instance of an object.
C:\temp\RSWebParts.cab: The Web Part deployment failed.

Why I didn't see it before (if you care, probably not relevant):

I'm on windows server 2008 and I was getting the access denied error, so I changed stsadm.exe to run as administrator in properties. This caused it to run in a new window which immediately closed so I never saw any output and assumed it succeeded. I switch to calling the stsadm command from a batch file and only ran the batch file as administrator and now I can see the output.

I also noticed this in the event log:

SQL Database 'moss_Central_Admin_Content' on SQL Server instance 's1' not found. Additional error information from SQL Server is included below.

Cannot open database "moss_Central_Admin_Content" requested by the login. The login failed.
Login failed for user 'dom\greg'.

Update 2

I made myself dbo of that database and reran. STSADM said it was successful but I still don't see options for the new web parts.

Here's what I get with this command:

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsadm.exe -o enumwppacks

rswebparts.cab, http://serv/
rswebparts.cab, http://serv:8020/
rswebparts.cab, http://serv:8010/

I'm not sure it matters but when I use Sharepoint on the web, it uses port 8000.