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.
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'.
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.