DRAG DROP
You are planning to install an instance of Microsoft SQL Server for a SharePoint 2013 farm.
You have the following requirements:
Ensure that databases can be redirected to other servers.
Minimize potential security threats.
You need to install and configure the instance.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order.)
Answer: See the explanation
Explanation:
Explanation/Reference:
Box 1: Create a named instance of SQL Server.
Box 2: Configure the instance to use a custom port.
Box 3: Create a SQL Server alias and configure the farm to use the alias.
Note:
* To harden the security for SQL server it is highly recommend to install SQL Server with named instance
with custom port and block all default SQL specific ports.
* After the installation of SQL Server with named instance, we have to assign a custom static port
number for the SQL Service.
* After the SQL installation we go to the SharePoint side.
We have to configure the SQL Client Alias. Install & Configure SharePoint 2013 with SQL Client Alias