How to enable remote connections to MS SQL server?

Follow

Comments

4 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.

  • Avatar
    Ivan Postnikov

    Hello @Jason, thank you for notice.

    The article will be reviewed soon.

  • 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.".

     

  • 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

Please sign in to leave a comment.

Have more questions? Submit a request