3

I am planning to install SharePoint Server 2016 on a two-tier server farm consisting of an Application Server and Database Server. While running the SharePoint Products Configuration Wizard, at the 'Specify Server Role' screen, the following server roles can be selected:

  • Front-end
  • Application
  • Distributed Cache
  • Search
  • Custom
  • Single-Server Farm

With regards to the two-tier server farm: only the Application Server Role option appears above (and it seems that this would be selected on the Application Server), but I do not see any Database Server Role for the Database Server. Why is this the case? Is it still possible to setup a two-tier server farm with an Application Server and Database Server in SharePoint Server 2016?

2

I do not see any Database Server Role for the Database Server. Why is this the case?

Fundamentally, In the non-Standalone farm (Like Tow-Tire farm), the Sharepoint is not installed on the Database Server, so that we don't need to run the SharePoint configuration wizard on it to specify its role.

Once the SQL Server is installed on a server within the farm, and it has been specified during configuring the SharePoint configuration database. At this moment this server becomes has a Database role!

So It's normal behavior, to don't find the Database Role option listed in the New SharePoint Minrole.

enter image description here

For more details check Description of MinRole and associated services in SharePoint Server 2016.


Is it still possible to set up a two-tier server farm with an Application Server and Database Server in SharePoint Server 2016?

Yes, it's possible :)

  • Just prepare your database server.
  • In the second server, install the Sharepoint,

It prefers to create SQL Alias. For more details check Configuring SQL Server alias with SharePoint Server

  • Run the Sharepoint configuration wizard, Specify the Server name/ Alias and the Farm account credentials.

enter image description here

  • At MinRole, select the Application or Custom Server Role. (it's recommended to use Custom role!).

  • Continue to complete the SharePoint Configuration Wizard.


Check Also

  • Thanks for the detailed answer. What is the benefit of choosing the Custom Server Role over the Application Server Role? – synthesis Dec 10 '17 at 17:08
  • @synthesis You are welcome :) , Using The custom server role will provide you the flexibility to manage the custom application services that will be running on the server. especially, in your case, you have a SharePoint server that will work as WFE/App role! So, you should use the Custom role when you need to configure custom servers at the same time, to reduce the number of servers within the farm and this is will depend on your current topology and the current budget! – Mohamed El-Qassas MVP Dec 10 '17 at 18:09
  • Don’t forget that the feature update adds two new min roles (Cache+Web and Search+App). This allows for a 4SP server farm to be resilient and still remain in the min-role configuration without resorting to custom (or 8 servers as in the initial release). – Greg W Dec 11 '17 at 9:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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