Articles in this section

See more

How to enable remote connections to MS SQL server on a Plesk server?

Avatar
Leonid Gukhman
Updated
Follow
Plesk for Windows kb: how-to ABT: Group A

Applicable to:

  • Plesk for Windows

Question

How to enable remote connections to MS SQL server?

Answer

  1. Connect to the server via RDP.

  2. Press the Start button, go to Microsoft SQL Server XXXX (where XXXX is the MSSQL version) and click the SQL Server XXX Configuration Manager.

  3. Open the SQL Server Configuration Manager (Local) > SQL Server Network Configuration menu and click the Protocols for MSSQLSERVERXXXX (where XXXX is the MSSQL version).

  4. Make sure that the TCP/IP protocol has the Enabled status:

    Screenshot.png

  5. Double-click the TCP/IP protocol, go to the IP Addresses tab, and scroll down to the IPAll section.

  6. Specify 1433 in the TCP Port field (or another port if 1433 is used by another MS SQL Server) and press the OK button:

    Note: the specified port, e.g, 1433, must be opened in the firewall.

    If you use Microsoft SQL Server Management Studio to connect to SQL server with a custom port, you should use coma with the port for connection address like 203.0.113.2,1433.

    MSSQL TCP IP Properties

  7. Go to SQL Server Configuration Manager (Local) > SQL Server Services, right-click the SQL Server (MSSQLSERVER) service and press the Restart button to apply made changes:

    Screenshot_3.png

  8. Log in to Plesk.

  9. Go to Tools & Settings > Database Servers > MSSQLSERVER > Settings and click OK to reset cached connection settings.

Comments

6 comments

Sort by Date Votes
  • Avatar
    Unknown User

    I'd just like to make a correction here. The simplest way to restart the service is not to switch programs. You can do it from within SQL Server Configuration Manager; just select 'SQL Server Services' from the left-most pane, then right-click the service you need to restart, and click 'Restart'. No need to go find another program (Services), locate the service in a huge list and go through its menu options to restart it.

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Jason, thank you for notice.

    The article will be reviewed soon.

    0
    Comment actions Permalink
  • Avatar
    Marcela Rocha Santos

    I connected to my server via RDC, but can't open SQL Server Configuration Manager. 

    Error message: "An attempt was made to reference a token that does not exist.".

     

    0
    Comment actions Permalink
  • Avatar
    Denis Bykov

    @Marcela Rocha Santos

    Try out the solution provided on Microsoft forum:

    1. Open a Command Prompt and navigate to "%WINDIR%\System32".

    2. Re-register the required DLL files using the following command:

    for /f %s in ('dir /b *.dll') do regsvr32 /s %s
    0
    Comment actions Permalink
  • Avatar
    Ariel Lipschutz

    I am receiving this:

    Error: database_server_error__test__connection_error

    Failed to connect to the database server: SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: No connection could be made because the target machine actively refused it.

    0
    Comment actions Permalink
  • Avatar
    Pamir Alpha Technologies

    I am receiving this error;

    Error: database_server_error__test__connection_error

    Failed to connect to the database server: SQLSTATE[28000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'admin'.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles