Tuesday, July 21, 2009
The SQL Server 2008 Reporting Services Add-in for SharePoint is available for download at this location:
Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
The downloads include a readme_rsaddin.htm file, which contains complete instructions for installing and configuring the Add-in.
After running the rsSharePoint_x64.msi (installer) file, the setup appears to have finished. However, by following steps in the readme_rsaddin.htm file for activating the Add-in features, it is not possible to activate the features.
The reason it is not possible to activate the features is because setup experienced an error and the user does not have permission to add the feature to the site collection.
C:\Documents and Settings\SetupUser\Local Settings\TempOpen the log file, RS_SP.0.log
Within the log file, look for an error; for example:Activating feature to root site collection: https://centraladmin.domain.com******* User does not have permission to add feature to site collection: https://centraladmin.domain.com
To resolve this, either log in as a user that is a Site Collection Administrator on the Central Administration site collection or make the current user account a site collection Administrator by doing the following:
Navigate to Central Administration > Application Management > Site Collection Administrators.
Select the Central Administration site collection.
Add the desired user account as either primary or secondary site collection administrator for the site collection.
Once logged in as a Central Administration, Site Collection Administrator, run the rsSharePoint_x64.msi again, this time choosing the "Repair" option.
To verify the permission issue has been resolved, navigate to:
C:\Documents and Settings\nbisciotti\Local Settings\Temp
Open the log file, RS_SP.0.log
Within the log file, the entry should now read:
Activating feature to root site collection: https://centraladmin.domain.com
Activated feature for root site collection: https://centraladmin.domain.com
Next, navigate to Central Administration > Site Actions > Site Settings > Site Collection Administration > Site Collection Features
Activate the "Report Server Integration Feature"
Next, navigate to Central Administration > Application Management
The "Reporting Services" panel should now be available and visible. From here you can proceed with the SQL Server 2008 Reporting Services integration configuration.
Wednesday, July 01, 2009
SharePoint 3.0: Error: Access Denied When Activating Publishing Infrastructure, Site Collection Feature
When attempting to activate the "Office SharePoint Server Publishing Infrastructure" Site Collection Feature, an "Access Denied" error is presented.
* Start > Programs > Administrative Tools > IIS Manager
* Expand the Application Pools node, locate the application pool associated with the site collection that is experiencing an issue
* Right-Click the Application Pool and select "Properties"
* Select the "Identity" tab
* Note the user account
* Start > Programs > Microsoft Office Server > SharePoint 3.0 Central Administration
* Site Actions > Site Settings > Advanced Permissions
* Click "Groups"
* Click "Farm Administrators"
* New > Add Users
* Add Users: Type the name of the Application Pool Identity account
* Give Permission: Add users to a SharePoint group: Farm Administrators
* Add the Application Pool account to the Farm Administrators group
* Send E-Mail: Uncheck (you most likely do not want to send an email)
* Click OK
* Try again to activate the "Office SharePoint Server Publishing Infrastructure" Site Collection Feature
SharePoint - Access Denied When Enabling The Publishing Infrastructure Site Collection Feature http://www.sharepointblogs.com/george/archive/2009/03/24/sharepoint-access-denied-when-enabling-the-publishing-infrastructure-site-collection-feature.aspx
- ► 2012 (13)
- ► 2011 (27)
- ► 2010 (60)
- ▼ July (2)
- ► 2008 (45)
- ► 2007 (80)
Events / Conferences / User Groups
- AIIM Conference
- Boston Area SharePoint User Group
- Boston Azure User Group
- Enterprise Search Summit
- Microsoft Build
- Microsoft SharePoint Conference
- Microsoft TechEd
- New England ASP.NET Professionals User Group
- New England Oracle Applications User Group
- Oracle Applications User Group (OAUG)
- Oracle OpenWorld
- PeopleSoft Government Contractor Special Interest Group
- PeopleSoft Southern New England Users Group
- Quest International Users Group
- SharePoint Saturday
- SQL PASS
- SQL Saturday
- Startup Weekend