Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
Did you set up reporting services in the sharepoint mode? –  Sam Mar 16 '10 at 21:01
    
Do you mean setting up the reporting services database in sharepoint integrated mode? Supposedly I don't have to do that using this approach. –  Greg_the_Ant Mar 16 '10 at 21:26
    
@Greg_the_Ant was there any output from the stsadm command? Only thing I can think of right now is you are on Windows 2008 and didn't run your command prompt as an admin - but that should give you an "access denied" error. –  MattB Mar 16 '10 at 21:52
    
@Greg_the_Ant also - just remembered you should be able to do a "stsadm -o enumwppacks" and it will give you a list of any deployed web part packages. RsWebParts.cab should show up in this list. –  MattB Mar 16 '10 at 21:54
    
@MattB, there was an error (see updated question). I'm going to try becoming dbo of moss_Central_Admin_Content. I'll report back later. –  Greg_the_Ant Mar 16 '10 at 22:52

1 Answer 1

up vote 1 down vote accepted

The answer to the original question was that on Windows 2008 (due to UAC) you need to run STSADM from an administrative command prompt.

See the comments on the question and Greg_the_Ant's updates for further discussion.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.