Good day all… Wondering if you might have seen this…
I have successfully updated client A and their upgraded environment is up and running good in test mode.
The most recent difference is that I applied the March 2013 CU to the target Sharepoint 2013 server.
So, I have backed up my SharePoint 2010 WSS_Content and am attempting to mount the database.
The mount fails (sort of). I need to do a dismount before I retry.
Anyway, the error is as follows:
Unknown SQL Exception 15151 occurred. Additional error information from SQL Server is included below. Cannot alter the role ‘SPDataAccess’, because it does not exist or you do not have permission.
I have attempted to grant the role to the database in SSMS, but it gives another error “Add member failed for DatabaseRole ‘SPDataAccess’.
This has started happening to me today. The Farm account has DBO access to the database. The upgrade goes to 4.62% and hangs. It then throws that error in log. Did you ever find a solution?
Check the Permission of the account which you used to run the mount/ Dismount command. The Permission to make those changes on database required the higher rights like dbo/sysadmin.
Run the command using the farm Admin account. The farm admin needs to be a dbo.
