When building a new 2016 multi server farm I can get the app server to talk to SQL but the WFE will not connect to the farm. The App serve sees it but will not connect. the error I am getting is 401 UNAUTHORIZED?

1 Answer 1


Looks like permission issue.

  • Make Sure the account which you login should have proper rights at the SQL Server. typically it is farm account or Install account which need Security Admin or DB creator rights.
  • Same account also be part of local admin on SharePoint server
  • Also try to pin the SQL server from the wfe server.
  • I have been using the network domain account (root account) to build all three servers (i.e. app server, sql server, wfe server.) I have had the three account added to all servers (i.e. SPSetup "Full control of all SP servers", SPFarm "Full control of all SP servers" & SPApp "Full control of SQL Server") But again loading/building all server with domain account. Is this not right?
    – Sonny
    Commented Feb 3, 2017 at 20:55

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.