SharePoint 2016, Sharepoint 2013, Sharepoint 2010, Windows Server 2012, Sql Server 2012,2014,IIS, Active Directory,User Profile Service, Managed MetaData Service, Search Service, Topology, Web Application, IIS, Site collection, List, Library, PowerShell, office web app, Windows Authentication, NTLM, Kerberos, Saml, ADFS, Active Directory Import, MIM, SharePoint 2016 Specify the Default Database Server – SharePoint

SharePoint 2016 Specify the Default Database Server

2016-07-04_01h00_33You are on the Default Database Server page(Central Admin > Application management > Under Database…Specify the default database server).

Use this page to set the default content database server.  When you extend new web applications, the content databases for those web applications are created on the default content database server unless you specify a different server. This database server will be used as default( unless you mention different) for all service application creation / creating new database etc.

Following Information required to change the Default Database Server.

  • Database Server Name: Name of the SQL Server
  • Account: Domain\user account which will use to connect the SQL Server. You can use SQL account as well but not recommended.
  • Password: Password of the provided account.

After entering the Required Information Click Ok.

Note: It is highly recommended don’t use the SQL authentication as there is the limitation of it.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *