If you have not finished the first two parts of this series then please read the following parts:
Step 3: Install SQL Server 2012 for SharePoint 2013 on AzureIn the last articles we saw how to create and configure network components and domain controllers. In this article we will see how to install and configure SQL Server 2012. Create SQL Database VMCreate Database Server VM --> Microsoft SQL Server 2012 SP1 Enterprise on Windows Server 2008 R2.Follow the steps. Choose Large Size and ensure the Affinity Group, Subnet and Windows Azure Storage Account are selected properly as shown below.Add SQL Server to DomainOnce the VM is provisioned, RDP into it and go to "Control Panel" --> "System Properties" and change the computer domain to the domain you created in Step 1. When connecting to the domain you will be asked user name and password. Enter the "sp_install" user and password and click OK. Your SQL Server will now be connected to your domain.Configure SQL ServerOnce SQL Server 2012 is provisioned, perform the following steps.
Change firewall settings
The Windows Firewall blocks both ports that SQL Server requires, client port 1433 and the high availability port 5022. We need to open the ports. To do that start Windows Firewall with the Advanced Security from "Start" --> "Administrative Tools".Click Inbound Rules then select "Add a new rule" then follow the wizard steps. Ensure the path to SQLsevr.exe is correct. Please note if this path is not correct then you will face issues when configuring SharePoint Server 2013. Let the default selection of "Allow the connection".Click on "Finish". This completes the SQL Server 2012 configuration. In the next article we will see how to install and configure SharePoint Server 2013 on Windows Azure.
Further Readings
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members: