As we don't have the credentials to central admin, sql server whenever facing problem related to jobs and user profile service unable to do anything.
Currently the issue is every 1 min the support account got login failure and it is displaying in evernviewer.Due to this the particular support account keep on locking.
I suspect it is job related. But to disable job again powershell is needed.For powershell even I install in the server again it needs credential.
I tried below 1. Update farm credential using stsadm
- Afraid these accounts are related to service accounts too .. update with new password may affect existing service.
2.I tried adding user as farm admin, but still we need sql access for the new user mapping to SharePoint Server Admin Group. http://blogs.devhorizon.com/reza/2012/03/07/adding-additional-farm-admins-to-an-existing-farm/
3.Checked in 14 hive logs but nowhere log is maintained
4.Using stsadm we cant disable job only delete option available. To find out which job is running we have option to list out jobs.
As we dont have sql credential is there any way to add a user in Sql server using command prompt. Then we can connect to server and can add new user as farm admin
Help me to access sharepoint central admin also sql server