Question
How to add an already installed Microsoft SQL server in Plesk?
Answer
Connect to a server via RDP.
Download and install SQL Server Management Studio.
Open SQL Server Management Studio:
Specify a required database server instance as a Server name
Select Windows Authentication as an Authentication
Under the database server instance name, expand Security > Logins > right-click on sa to open its Properties.
Set the required password - it will be used to register the instance in Plesk.
On the same window, click Status and apply the following changes:
Permission to connect to database engine: Grant
Login : Enabled
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
Start SQL Server Configuration Manager > expand SQL Server Network Configuration > select the database server instance name and enable the following options:
- Named Pipes
- TCP/IP
Note: If this SQL Server instance is installed on a remote Windows Server, allow remote connections by following instructions from this KB article.
In SQL Server Configuration Manager, click SQL Server Services > right-click on the SQL Server instance > Restart.
Go to Tools & Settings > Database Servers and click Add Database Server
- Fill in the fields:
Database server type: Microsoft SQL Server
- Host name or IP address: .SQLEXPRESS
" . " is required before a host name. If this SQL Server instance is installed in a different server, specify the IP address, for example 203.0.113.2SQLEXPRESS
- The correct hostname is a server name from Step 3
Administrator's username: sa
Administrator's password: the password from Step 5
Click OK.
