Navigate to Virtual Machine section in your Asia.Cloud Control panel and hit Create New link.
Select Windows 2016 from drop down menu and hit Select Windows button.
Select Windows 2016 with SQL Server 2016 template from drop down menu and hit Select Template button.
In the Choose Plan drop down box select the specs of your VM.
On the next page enter the name for your VM and the password for your Administrator user.
Select Billing Period for your VPS and hit Create Virtual Machine button.

Start SQL Server Configuration Manager by going to Start // Microsoft SQL Server 201x // SQL Server 201x Configuration Manager
Enable TCP/IP Protocol under SQL Server Network Configuration // Protocols for MSSQLSERVER and under SQL Native Client xx Configuration // Client Protocols
You may disable Shared Memory and Named Pipes protocols.
Click on SQL Server Services, right click on SQL Server (MSSQLSERVER), and select Restart from drop down menu
Open the default TCP/IP port 1433 in Windows Firewall so you can connect to your SQL Server instance. You can do so by starting the command prompt as administrator and running the following command:

netsh advfirewall firewall add rule name="SQL Server" dir=in action=allow protocol=TCP localport=1433

Article ID: 36, Created: November 22, 2018 at 6:27 PM, Modified: November 22, 2018 at 8:53 PM

Installing and Configuring SQL Server Instance

Add Feedback