I'm testing out upgrading our Sharepoint 2010 farm to Sharepoint 2013.
Fortunately for me we have very few specialties in our farm, very straight forward.
But when setting up the new MySites, when I add one of the old content databases (and so far only for this one!) it starts spitting out a few (20 or so) messages about peoples "sites is in a partially provisioned state". The site still works fine after upgrade but I don't like having errors like this so I digged deeper.
Googling didn't help, I only found an article about Sharepoint Online so that wasn't a big help.
But looking into the details in the ULS for these jobs I see the following critical message:
"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 like that error message because at first it seems pretty clear. But unfortunately I'm doing this all with a farm account that is sysadmin on the entire SQL instance, so permissions aren't a problem. But as far as I can see there is no SPDataAccess role on either this instance or the "old" one where this database came from!
I thought about messing in the SQL when I remembered an old quote from my Sharepoint 2010 instructor - "the second you go and edit the SQL yourself you're on your own" so I stopped there.
Any suggestions? A "ignore this error" is pretty much useless since I don't a choice in the matter, but I still want to know what the hell is up with this error?
Kind regards // Kris
- Edited by Kristoffer75 Friday, February 07, 2014 11:03 AM