Applicable to:
- Plesk for Windows
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:
-
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:
-
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.2\SQLEXPRESS
- The correct hostname is a server name from Step 3
-
-
Administrator's username: sa
-
Administrator's password: the password from Step 5
-
-
Click OK.
Comments
0 comments
Please sign in to leave a comment.