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,759 questions

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Koffiebear 0 Reputation points
    2023-06-28T05:11:43.6233333+00:00

    I ran into both of these issues as well.

    I found the SQL Server Configuration Manager in my Systems32 files.

    As for the error when connecting to the server, it took me a while to see that somehow I have two instances of SQLEXPRESS server and it was the other. I am not sure when or how that happened. I am still new and learning SQL. I discovered the second instance while trying to check for updates to SQL in the SQL Installation Center in which a YouTube video said would also solve this issue.

    0 comments