Sql Server Configuration Manager not showing in windows 10

Jimmy Winblad 1 Reputation point
2020-11-18T08:48:21.623+00:00

Hi.
I am trying to setup sql management studio and i cant connect to a server name. Been trying to find the sql config manager but i cant find it anywhere on my computer, and i have searched on youtube and on google and tried many solutions but i simply cant solve it.

Even checked my firewall if it blocks the ports etc. Im not very good at this so please how do i solve this? Is it possible to download the configuration manager somewhere? I have been trying to look for it but i cant find any download link.

Here is what it says:

TITLE:
Connect to Server A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,607 questions

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,071 Reputation points Microsoft Vendor
    2020-11-19T09:22:54.67+00:00

    Hi @Jimmy Winblad ,

    > Sql Server Configuration Manager not showing in windows 10

    Using below methods to access SQL server configure manager.

    A: Navigate to c:\windows\system32 and look for a file with the name SQLServerManagernn.msc, where nn is the version of SQL Server you have installed. For SQL Server 2019, the name is SQLServerManager15.msc. You can double-click on it and you'll see a result. You can also make a shortcut on the desktop if you like.

    41111-screenshot-2020-11-19-170452.jpg

    B: A much simpler way is to run the Computer Management applet from Control Panel→Administrative Tools→Computer Management, where you should find the configuration manager installed

    41102-screenshot-2020-11-19-170526.jpg

    > (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

    Please follow below steps to troubleshot the issue,

    1. Make sure SQL Server Service is running
    2. If a named instance, make sure SQL Server browser service is running. Make sure the instance name is spelled correct.
    3. Make sure SQL Server is configured to allow remote connections
    4. Examine the SQL Server error log for messages confirming that SQL is listening on the expected network interfaces and ports
    5. Test server connectivity with PING from the client machine
    6. Test port connectivity using TELNET to the server and port (from step 4) from the client machine. For example
      TELNET <server-name> 1433
    7. Check firewall settings if step 5 or 6 connectivity test fails

    If you have some confuse about the steps, please refer to Resolving could not open a connection to SQL Server errors or Troubleshoot connecting to the SQL Server Database Engine to get more information.

    By the way, did you SQL server is default instance( MSSQLSERVER)? If that you can use computer name to connect to SQL server, if your SQL is named instance(such as SQL 2019), you need to use <computer_name>\<instance_name>(such as node1\SQL2019) to connect SQL server. Please refer to Lesson 1: Connecting to the Database Engine.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it.

    9 people found this answer helpful.
  2. tibor_karaszi@hotmail.com 4,301 Reputation points
    2020-11-18T15:15:23.783+00:00

    OS updates on Windows removes the MMC registration for SQL Server configuration manager, for some very very strange reason.

    Use the Computer Management tool instead. You'll find SSCM in there.

    Here's a blog post on that subject (including how to get it back): https://blog.sqlauthority.com/2019/03/01/sql-server-sql-server-configuration-manager-missing-from-start-menu/

    3 people found this answer helpful.
  3. Shashank Singh 6,246 Reputation points
    2020-11-18T10:45:11.363+00:00

    There are 2 problems you are facing

    1. Unable to connect to SQL Server
    2. SSCM not available.

    For 1st issue you can refer to 2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx

    For 2nd issue, you can go to services and find SQL Server configuration manager and manage it, although not completely.

    I would like to know your exact issue

    EDIT: Taking cue from @tibor_karaszi@hotmail.com answer. I completely missed your question I guess. Yes for windows 10 you have different way to launch SSCM. Microsoft has documented it

    To open SQL Server Configuration Manager, on the Start Page, type SQLServerManager13.msc (for SQL Server 2016 (13.x)). For other versions of SQL Server, replace 13 with the corresponding number. Clicking SQLServerManager13.msc opens the Configuration Manager. To pin the Configuration Manager to the Start Page or Task Bar, right-click SQLServerManager13.msc, and then click Open file location. In the Windows File Explorer, right-click SQLServerManager13.msc, and then click Pin to Start or Pin to taskbar.

    0 comments
  4. Sophia 1 Reputation point
    2021-02-16T17:43:15.51+00:00

    After Windows update I also couldn't connect to the SQL server. Moreover, under the Windows Start section I couldn't find the Configuration Manager anymore.
    Cathyji-msft's answer helped me out here. Thanks

    0 comments
  5. Luiz Henrique de Oliveira Monteiro 0 Reputation points
    2023-01-27T23:28:01.84+00:00 
    here it worked like this SQL Server 2019 - Windows 10
then just create your odbc that connects normally
    0 comments