How to Install MS SQL server to VPS Server?

0
6993

We place the SQL Express database installation package in the system so that you can install the SQL service as per requirement. There are different ways to install MSSQL server to VPS server. In below, we have developed an easy-to-follow guide to teach you how to install MSSQL server to your Windows VPS server in WebSitePanel.

Steps of Installing MSSQL Server to VPS Server in WebSitePanel

1.Log into your WebSitePanel, find Virtual Private Servers. Then, click your VPS server and choose DVD option. Next, click Insert option after Popular Software, and then choose SQL_2012_Express option among the application tools.

Installing MSSQL Server to VPS Server in WebSitePanel 1

2. The installation kit will take some time to extract. Once the file is extracted, the Center panel will open. Next, click on the first option in the SQL Server Installation Center.
Installing MSSQL Server to VPS Server in WebSitePanel 2

3. Check the box saying “I accept the license terms”. Click on “Next” at the bottom.

Installing MSSQL Server to VPS Server in WebSitePanel 3

4. Then, the “Product Updates” window will appear. Click on “Next”.

Installing MSSQL Server to VPS Server in WebSitePanel 4

5. In the “Feature Selection” window, check the boxes that say “Database Engine Services”, “Management Tools – Basic”, and “Management Tools – Complete”, as shown in the screenshot. Leave the other boxes unchecked.

Installing MSSQL Server to VPS Server in WebSitePanel 5

6. On the “Instance Configuration” window, don’t make any changes of the default settings. Let them remain the same and click on “Next”.

Installing MSSQL Server to VPS Server in WebSitePanel 6

7. On the “Server Configuration” window, keep the default settings and don’t make any changes. Click on “Next”.

Installing MSSQL Server to VPS Server in WebSitePanel 7

8. On the “Database Engine Configuration” window, check the “Mixed Mode” radio button and enter your new SQL server password twice. Now, click on “Next”.

Installing MSSQL Server to VPS Server in WebSitePanel 8

9. On the “Error Reporting” page, check the box if you want to send error reports to Microsoft. If you don’t want to send the error reports, keep it unchecked. Then, click on “Next”.

Installing MSSQL Server to VPS Server in WebSitePanel 9

10. This will put the installation into process. It will take several minutes to be completed. Once it is completed, the “Complete” window will appear as given in this screenshot.

Installing MSSQL Server to VPS Server in WebSitePanel 10