i am involved into an issue. I connected the SQL server using the SQL Credential not domain account( due to some issue). Now i want change the SQL account for the services( UPA, MMD and Search service) as well as WebApplication.
For content DB(WebApplication)..its easy i detach the content db and attach it using new SQL account & password.
But now i am confused, how can do the same thing with UPA, MMD, Search Servic and others.Please guide me how can i perform this step?
Based on my knowledge, you can update a service application by using central administration, such as change the authentication method. You need to ensure you have the required permissions to perform this procedure. To update a managed metadata service application,
you must be both a member of the Administrators group on the computer running the SharePoint Central Administration Web site, and a member of the Farm Administrators group.
I prove you a link about how to create, update, publish, or delete a managed metadata service application for your reference:
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.