Question
How to add an already installed Microsoft SQL server in Plesk?
Answer
To use MSSQL database server with your hosting server:
-
Connect to a Plesk server via RDP.
-
Download and install SQL Server Management Studio.
-
Open SQL Server Management Studio:
-
Under the database server instance name, expand Security > Logins and right click on sa > Properties.
-
Set the required password – it will be needed to connect an instance to Plesk.
-
On the same window, click Status and apply the following changes:
-
In SQL Server Management Studio , right click on the database server instance name > Properties > Security > select SQL Server and Windows Authentication mode and click OK
-
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
-
Restart the SQL Server service at Start > Services.
-
Go to Tools & Settings > Database Servers and click Add Database Server
- Fill in the fields:
-
Database server type: MS SQL
-
Host name or IP address: .SQLEXPRESS
-
” . ” is required before a host name
- The correct host name is a server name from the Step 3
-
-
Administrator’s username: sa
-
Administrator’s password: the password from the step 5
-
-
Click OK.
Â