We are currently doing a SharePoint 2010 to 2013 migration and are running into some issues with getting Access services 2010 web databases to work in SharePoint 2013. We’ve added the reporting services for SharePoint , and made sure that Access 2010 is properly configured in Central Administration. There are also workflows associated with these sites that we are unable to access. Does anyone have any experience with configuring this and getting the sites to work?
I’ve been following information in this link:
https://technet.microsoft.com/en-us/library/ee748653.aspx
Your help and suggestions are appreciated!
In brief the share point 2010 site which needs to be migrated should be converted to claims format and then migrate it to 2013. But a word of caution , do not directly change the SP 2010 site to claims format in a production environment as it will not allow existing windows accounts to login and existing SharePoint 2010 site will be no more operational.
Below power shell script converts classic mode site to claims mode:
This script converts user accounts to claims format:
On executing the first script (to enable claims authentication) the SharePoint Content Database is made ready for claims based authentication but the already existing site users were windows users,are not “migrated” to be understood by claims authentication.
We use the second script to “migrate” the users. MigrateUser($true) will convert all user accounts to claims format. After running this script user accounts are converted in the database to claims format, therefore, user names are read correctly by SharePoint therefore, permissions for users are associated correctly by SharePoint hence the site permissions work correctly. Learn more about SharePoint Migration Services or SharePoint 2013 migration to sharepoint online
