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.
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
- added Farmaccount as dbowner in Content DB
- ran latest CU patches on Farm (June 9,2020)
- Test-SPContentDatabase - does not show any Upgrade blocking errors.