Test

 

Configure the Windows Firewall to Allow SQL Server Access

Problem: A warning message is displayed in SQL Sever 2014 Setup "Install Rules" step.

Rule "Windows Firewall" generated a warning
The Windows firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules' documentation at http://go.microsoft.com/fwlink/?LinkId=94001 for information about ports to open for each feature. 

Solution: Needs to open up relevant ports in the Windows firewall. In addition, some other parameters must be set depending on the components installed, the setup scenario, and the version of the SQL server.

SQL Server 2008 R2 Specific Instructions
SQL Server 2014 Specific Instructions
SQL Server 2016 Specific Instructions

Steps: To pass the Installation Rules step of the SQL server 2014 setup, open up port 1433.

  1. Go To Windows Firewall

Then click on Advanced Settings in the Allowed Apps window.

Click on Allow another App..

Create a basic Virtual Machine using Azure CLI

First, create a resource group

> az group create \
--name MyResourceGroup \
--location CentralUS \
--tags MyTag 

Then create the VM and provide the resource group created in the above step

> az vm create \
--name MyFirstVM \

--resource-group MyResourceGroup \

--image Win2016Datacenter \

--admin-username Hasitha \

--admin-password Password*1234 \

--size Standard_D2ads_v5 \

--public-ip-sku basic \

--os-disk-size-gb 128 

 

Troubleshooting MSI Installer

msiexec /i my_installer.msi /l*v install.log

This will create an install.log file on the same folder and should include more detailed info about what went wrong.

C# Convert Time Zone Value

 DateTime nzTime = new DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month,
                System.DateTime.Now.Day,
                System.DateTime.Now.Hour,
                System.DateTime.Now.Minute,
                System.DateTime.Now.Second);
                
             string lkZoneId = "Sri Lanka Standard Time";

             Console.WriteLine($"The date and time value for {lkZoneId} : 

                {TimeZoneInfo.ConvertTimeBySystemTimeZoneId(nzTime, lkZoneId)}");