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 | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

6 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Shashank Singh 6,251 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 @[email protected] 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.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.