Are you trying to enable MSSQL Database remote connection in Plesk?
This guide will help you.
Remote access is the ability to get access to a SQL Server from a remote distance in order to manipulate data which are located on that SQL Server. The SQL Server instance to allow the protocol being requested. Allow access through the Window Firewall.
Usually, the firewall blocks all external remote connections due to security reasons. So many of our customers approach us to enable remote access. We do it manually by adding the remote IP address or subnet to the allowed list.
By default, this MSSQL remote connection is disabled.
Here at Ibmi Media, as part of our Server Management Services, we regularly help our Customers to perform Plesk related queries.
In this context, we shall look into how to enable MSSQL remote connection and fix errors.
How to enable MSSQL Database remote connection in Plesk ?
Now let's take a look at how to enable MSSQL remote connection.
In Windows Plesk, there is an option to allow remote connections.
Here is an example,
1. For that, we log into the Plesk control panel then we create the database that we need to access remotely.
2. Then, we click on the Databases tab from the left-side menu and click Add Database.
3. We enter a Database name and select the Database Server type "MSSQL".
4. On a Related site, we select a domain name from the drop-down list. Also, we ensure that Create a database user is selected.
5. After that, we enter a Database user name and password.
6. Next, we choose to Allow remote connections from the option for Remote access and enter the IP addresses or subnets that need remote Database access,
7. At last, we click OK.
How to fix common MSSQL errors ?
We've dealt with many problems while managing MSSQL.
Now let's see the major reasons for MSSQL errors and how our Support Experts fix the main SQL errors.
Problems with remote network connections settings:
Recently, one of our customers had a problem while connecting to SQL remotely. When he tried to connect SQL remotely to the Plesk database he couldn't connect.
On checking, we found that the remote network connections were disabled for the IP address.
Therefore, we enabled the remote network connections for the corresponding IP address through the SQL server configuration manager.