I need your help. below is the information. our DBA has restored SQL db to destination SQL server .

SP 2013 Content DB version : 15.0.5249.1001

I have user SP_prd_Setup( who is admin on APP and WFE machine and I used this account to install SharePoint.)

on SQL server : same user has sysadmin,security admin,dbcreator,public roles in SQL instance and db_owner role on content DB : SP_Intranet_Content).

with that user (SP_prd_Setup) i am mounting DB using PS and i am getting below errors in ULS Logs. and Mount process stucks at 4.15% forever and it freezes database in SQL server too.

Errors :

1 )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.

2 )SqlError: 'Cannot alter the role 'SPDataAccess', because it does not exist or you do not have permission.'

I have tried below options but no luck

  1. added Farmaccount as dbowner in Content DB
  2. ran latest CU patches on Farm (June 9,2020)
  3. Test-SPContentDatabase - does not show any Upgrade blocking errors.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.