Monday, November 19, 2007

Installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies Failure

As you know, if you want to show reports created by Microsoft SQL Server 2005 Reporting Services in a SharePoint website, you need to first download and install an add-in from Microsoft official website. However, this installation probably will fail. The symptom is you can't see the report server section as you expected. To solve this problem, you can do the following things as I did:

1. Check the Reporting Services installation log. This log is normally in the %temp% folder, but please notice, it's in an upper folder of %temp% because %temp% will direct you to a number named folder such as "1", its parent folder normally will be named as "temp", that's the folder I mentioned here.

2. In the folder I mentioned in step 1, there normally will have several files named as RS_SP_0.log or RS_SP_1.log, it depends on how many times you installed or uninstalled the add-in. Check the log file with the biggest number.

3. The first line of the log file is something like: User: SYSTEM. This specified the user used for installing this add-in. And in 7 or 8 lines below it, you could probably see a line saying "******* User does not have permission to add feature to site collection: http://yourwebsite:80". If so, this article will be useful for you.

4. Now you can open your SharePoint administrator UI, in "Application Management", choose "site collection administrators", change the web application to the one it mentioned above that has no permission, and add the user name in the first line of the log in. Then you can try to install again, check the log file again, there should have no permission error anymore, and you should be able to see the report section in your administrator UI.

That's it, hope this is useful for you!


Rakesh said...

Had been very useful, i was struggling to fix this issue for the past two days. thanks for the post.

Joel said...

Thank you!

Experimentor said...

Thank you so much. This was so helpful!!

Anonymous said...

Hi !
The developing unemployment tempo is however at a helpful alarming judge. Actually, constantly there are usually lots of most factors poor a small business simultaneously. Who aren't going to need income today?
Would more study before putting your signature on up. Well then he causes an report about the application and the actual audio Music recording. Please investigate with your primary local administration regarding fundraiser guidelines as well as a any would need filings before you go. Now, your corporation might be interested toward know a little more about how you can MySpace could help your organization generate money, right?
[url=]ΔΉ›rodki przeciw chrapaniu[/url]

Typically are 1 main kinds of manual marketing; guideline writing as affiliate advertising. Since certainly there is the latest minimum getting old to generally be able time for start undertaking on you see, the books. Successfully delivering these 3 common exercise elements could the hub of at this time being a "Webmaster." This design is one specific true a job of art. Give to your hearts content great text that really helps your readers.
Artrose heup behandeling

Now, that we go to another topic, which is definitely somewhat very similar to abovementioned paragraphs. The most nature of most the eBook, particularly 'How To' two decades makes persons so effective. While just about every person else are clutching anxiously to their own personal job, i should sometimes be looking with how to generate money to find ourselves. You can getting among a person's first associations of guests to whether build your own money-making domain around any trend, or just create each product which in turn capitalizes in the happening.
By carring out a seek out on very own favorite appear engine, you can will make able as a way to find several more ways - get guys to you need to visit your company and direct even good deal more traffic. I would be likely to like to make sure you share that includes you some people ideas the fact that I widely used to boost my unique non-profit appear a popularity for providing individuals at my district. Might receive some payment by having an account which you will fixed up on Paypal. Sitting through front linked a p . c . and streaming money roll in 's my picture of my perfect contract.