0

I recently added a new user into farm administrators group from central administration website, and from SQL server I found below logs:

Login failed for user 'xxxx\usr1'. Reason: Failed to open the explicitly specified database 'sp_Config'. [CLIENT: xxxx]

Any help would be appreciated!

1 Answer 1

1

Generally, Login failed in SQL , mean the user does not have elevated privileges to access a specific database.

Regarding your issue , When you add "xxxxx\usr1" in Farm Administrators group, it will have permissions and responsibility to can perform some administrative tasks in Central Administration on the farm, and this will require access to SharePoint Databases like configuration database,

So to avoid login failed or access denied issue ,you should make sure that :

  • the user has access to SQL Server level and a db_owner and SharePoint_Shell_Access for all SharePoint databases.

Meanwhile, if you need to provide this account a full control on the Central Admin and PowerShell,you will need to do the following

  • the user is added to Local Administrator group on all server in Farm.
  • the user is added to Central Administration Farm Administrator Group.
  • the user is added to Web Application Policy with FULL control.
  • the user has access to SQL Server level and a db_owner and SharePoint_Shell_Access for all SharePoint databases.

For more details check

1
  • 1
    these are too much permission for the farm administrator account, put a serious security risk, that person just need the shelladmin right
    – Waqas Sarwar MVP
    Nov 29, 2016 at 14:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.