How to add a new instance of existing MS SQL database server to Plesk?

Created:

2017-07-18 17:53:13 UTC

Modified:

2017-08-16 16:52:51 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to add a new instance of existing MS SQL database server to Plesk?

Applicable to:

  • Plesk for Windows

Question

How to add a new instance of existing MS SQL server to Plesk? For example, a second instance of MS SQL 2012 SP3 in addition to already existing one.

Answer

Note: In order to add an existing MS SQL database server instance to Plesk , please refer to the appropriate article.

In order to install a new instance of MS SQL server in addition to already existing one, please proceed the following steps:

  1. Download and run an installer of appropriate version SQL server from Microsoft website, for example, SQL Server® 2012 Service Pack 3 (SP3) Express , which is installed with Plesk by default.
  2. Proceed with the steps of installation.
    1. Click New SQL Server stand-alone installation or add features to an existing installation .
    2. In the new windows choose the option Perform a new installation of SQL Server 2012 .
    3. During installation process choose the following options:
      • the name of the new instance (for example, NEWINSTANCE )
      • Authentication Mode: Mixed Mode and the password for system administrator user (sa).
      • Other options may be left as default.
    4. Complete the installation of the new instance.
  3. Open SQL Server Configuration Manager > expand SQL Server Network Configuration > select the database server instance name and enable the following options:
    • Named Pipes
    • TCP/IP
  4. Restart the service SQL Server (NEWINSTANCE) service at SQL Server Services .
  5. In Plesk, go to Tools & Settings > Database Servers and click Add Database Server .
  6. Type in the following information:
    • Database server type: MS SQL
    • Host name or IP address: .\NEWINSTANCE
      • ".\" is required before a host name
      • The correct host name is a name of the new instance from the Step 2
    • Administrator's username: sa
    • Administrator's password: the password from the step 3
  7. Click OK.

Have more questions? Submit a request
Please sign in to leave a comment.