As I understand, the user profile service is created using the farm account as a workaround to resolve the User Profile Sync issue but I noticed that when I try to backup the Farm, I run into this error:
FatalError: [SharePoint_User_Profile_Service_Application_SocialDB] Cannot open database "SharePoint_User_Profile_Service_Application_SocialDB" requested by the login. The login failed.
Login failed for user 'Demo\SPAdmin'
This obiously means that the account under which the backup job is run doesn't have access to Social DB. Except for for User Profile Service DBs, all the other DBs were created using the 'Demo\SPAdmin' account which is the install/setup account, thus the farm
account is the DB Owner of each of the User Profile Service Applications DBs.
Can someone please clarify if it is normal for the Farm account to be the DB owner of each of the UPS DBs? Also is it okay if I changed it to the 'Demo\SPAdmin' account so that I can run the backup without running into permission issues? Thanks.