Windows Server 2008R2
Enable dot Net 3.5 Features. If we don’t enable Dot Net 3.5, we would get the below error during the installation of the SQL Server.
To enable dotnet 3.5, we can enable at ad ”Application Server” role.
Install dot Net framework 4. This is to work around the below error during the installation . The application can be download from here .
Microsoft .NET Framework 4.0 installation has failed with exit code 1.
Error writing to file: DTEParseMgd.dll. Verify that you have access to that directory.
Installation SQL Server 2012
The warming message is due to the firewall rule. We would add the new rule later.
Configure the Port number
This change require bounce the SQL Server.
Add firewall rule
netsh advfirewall firewall add rule name="ICMP Allow Incoming V4 Echo Request by WORKGROUP" protocol=icmpv4:8,any dir=in action=allow
netsh advfirewall firewall add rule name="SQLServer" dir=in action=allow protocol=TCP localport=7001