Installing and Configuring SQL Server Instance

Ordering and Installing VPS with SQL Server Instance

  • 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.

Complete SQL Server Installation

 

Configuring SQL Server Protocols and Ports

  • 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
 
 

Add Feedback