Access Denied on the site collection after migrating form MOSS 2007 to SharePoint 2010.

We have recently migrated from the Moss 2007 to SharePoint Server 2010 and after migration we have several user complain about that they get access Denied error message on accessing parent site collection despite of they are having access on the site.

Error: Access Denied on the site collection level, though they have permissions. 

Background:

We user to activate a feature in the MOSS 2007 using stsadm -o activatefeature -name “Feature Name” -url  https://siteurl.net/sites/sites, after the site creation to have Branding enabled on it. 

After Migration, this feature is automatically activated on the web application level. Hence there is no need to activate it manually to apply standard branding on the newly created site. 

Troubleshooting:

-          Checked user permission on the group.

-          Added the user explicitly to the SharePoint group or individually.

-          Removed the user form the site collection and added again.

-          Added the user to site collection admin group. 

Note: We have seen Master page Gallery on the site collection level is using the unique permissions. Where as it has to be inherit from the site collection.

Resolution:

-          Added the NT Authority\Authenticated Users to the Master Page Gallery with Read permissions.

-          Change the permissions of the site to inherit form the site collection level.

-          Add the NT Authority\Authenticated Users to the style library with Read Permissions. 

Applied To:

SharePoint 2010. SharePoint Foundation 2010. SharePoint Server 2013.

Site Collection Codes

Parameter value	Description
GLOBAL#0	Global template
STS#0	Team Site
STS#1	Blank Site
STS#2	Document Workspace
MPS#0	Basic Meeting Workspace
MPS#1	Blank Meeting Workspace
MPS#2	Decision Meeting Workspace
MPS#3	Social Meeting Workspace
MPS#4	Multipage Meeting Workspace
CENTRALADMIN#0	Central Admin Site
WIKI#0	Wiki Site
BLOG#0	Blog
SGS#0	Group Work Site
TENANTADMIN#0	Tenant Admin Site
ACCSRV#0	Access Services Site
ACCSRV#1	Assets Web Database
ACCSRV#3	Charitable Contributions Web Database
ACCSRV#4	Contacts Web Database
ACCSRV#6	Issues Web Database
ACCSRV#5	Projects Web Database
BDR#0	Document Center
OFFILE#0	(obsolete) Records Center
OFFILE#1	Records Center
OSRV#0	Shared Services Administration Site
PPSMASite#0	PerformancePoint
BICenterSite#0	Business Intelligence Center
PWA#0	Project Web App Site
PWS#0	Microsoft Project Site
SPS#0	SharePoint Portal Server Site
SPSPERS#0	SharePoint Portal Server Personal Space
SPSMSITE#0	Personalization Site
SPSTOC#0	Contents area Template
SPSTOPIC#0	Topic area template
SPSNEWS#0	News Site
CMSPUBLISHING#0	Publishing Site
BLANKINTERNET#0	Publishing Site
BLANKINTERNET#1	Press Releases Site
BLANKINTERNET#2	Publishing Site with Workflow
SPSNHOME#0	News Site
SPSSITES#0	Site Directory
SPSCOMMU#0	Community area template
SPSREPORTCENTER#0	Report Center
SPSPORTAL#0	Collaboration Portal
SRCHCEN#0	Enterprise Search Center
PROFILES#0	Profiles
BLANKINTERNETCONT	Publishing Portal
SPSMSITEHOST#0	My Site Host
ENTERWIKI#0	Enterprise Wiki
SRCHCENTERLITE#0	Basic Search Center
SRCHCENTERLITE#1	Basic Search Center
SRCHCENTERFAST#0	FAST Search Center
visprus#0	Visio Process Repository

Cannot open the excel files in Sharepoint 2010

Its not a issue actually its just a setting that has changed may be after Migration to 2010.

Issue : Users cannot open excel files in SharePoint 2010 from the Library and get an error

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.
To create an Excel Services Application trusted location, contact your system administrator

Normally what we tend to do is we will go to the administrator and ask him to add the library to the trusted location .

Not need . No setting to be made on the server it is just a Library setting which can be changed from the site itself . Until you want to use excel web services ( Please make a note of this )

Cause : By default the files are designed to open in browser . So it is checking for trusted location   

Resolution :  

=> Go to the Library
=> On the top click on Library and go to Library settings .
=> Under General settings you will find Advanced settings 
=> Over there you will find the option which by default is set to open in Browser 
=> you need to set it to Open in Client and there you go . 
=> Click OK and you are done .

Hope it helps and you don't disturb the administrators :)