Protecting a SharePoint farm that uses SQL aliases

This recipe will cover the information that you need to understand how to protect a SharePoint farm that is configured with SQL aliases.

Getting ready

The purpose of having a SharePoint farm using SQL aliases is that it makes it possible to provide a name for SQL that the SharePoint servers query, instead of the actual SQL server NetBIOS name. This makes the SQL server hardware easy to change as well as making it easy to replace virtual SQL Servers during the expansion of the SharePoint farm.

How to do it...

To make the protection of the SharePoint farm operational, it is important that the SQL alias has some specific configurations, as listed here:

• You must only use TCP/IP aliases

• You must configure SQL server aliases and define all SQL aliases in the farm on the frontend web server

The configuration is performed in two steps. First, you must install the components of the SQL server client connectivity on the frontend web server.

The second step...