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

Follow

Comments

7 comments

  • 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
    Rahmat S. Masror

    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
  • Avatar
    Sreehari Susarla

    I am also receiving the same error, please do provide some solution

    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 

     

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request