going through my list for things I need to prep for in my upcoming Sharepoint 2010 installation.
We'll be installing SP2010 Enterprise to make use of the BI components, with the web server on it's own VM. We'll then use our existing SQL Server (2005) to host all SP databases. Finally, we also have an existing SQL Analysis Services implementation (2008), of which we want to consume reports out of.
That being said, I can use help with any\all of the following:
- From what I can gather, we need the Sharepoint Reporting Services Add-In installed.. somewhere. Where would that go?
- I've also seen older articles mention that the SQL Analysis Server will need a minimal SP installation to have the SP object model, but I'm not sure if this is still necessary.
- I'm also concerned that we already have the reporting services setup as a standalone installation, I don't want to screw up reporting for our data warehouse team (unless I have to) by setting up the reporting services for sharepoint.
- I have limited exposure to any BI\Reporting Services at this time, but this will definately be a key component for our SP rollout. Links to any articles, blogs, papers, and\or good books would be most appreciated.