SQL Aliases are optional ( but recommended ), and are a great way to configure your SharePoint environment. They allow for flexibility in case the SQL instance is changed, or the server names/IPs change then it’s possible to only “ re-point ” to the new servers. This way, there’s no need to reinstall SharePoint for the new server/instance. SQL Aliases are configured on each SharePoint Server . This is very important to remember! Let’s dive in and configure our aliases. Run cliconfg utility on SharePoint Server On Windows Server 2012 R2 & Windows Server 2016, we have an utility called cliconfg . There are 2 versions: 32-bit and 64-bit. In this blog post, we will be installing the 64-bit version ( 32-bit would be for apps compatibility, and located at C:\Windows\SysWow64 ) Log into the SharePoint Server Browse to C :\Windows\System32 Double-click on cliconfg cliconfg utility location When the...