Our organisation is upgrading from SP2010 + PWA to SP2013.
Having followed the process detailed on TechNet (http://technet.microsoft.com/en-us/library/ee662104.aspx), the test-spprojectdatabase PowerShell command reported that required database roles were missing on the new combined PWA database.
I manually created the roles as detailed here: http://social.technet.microsoft.com/Forums/en-US/projserv2010setup/thread/c152e658-a0f0-464d-8428-ddc156102542/ however I am unable to assign the relevant roles and schema permissions (CRUD) to the PSDataAccess role. I think this is stopping the import of sites and projects to our new 2013 environment.
Scripting the commands in SQL Studio shows me the message: "Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself" - however I was able to assign them to the dbo schema... It's just the others that don't work!
Any ideas?
Thanks!
