question

JimmyWinblad-8183 avatar image
0 Votes"
JimmyWinblad-8183 asked Terry-2302 commented

Sql Server Configuration Manager not showing in windows 10

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JimmyWinblad-8183,

Any update for this thread? Did the replies could help you? If the response helped, do "Accept Answer".

Best regards,
Cathy

0 Votes 0 ·
Shashank-Singh avatar image
0 Votes"
Shashank-Singh answered Shashank-Singh edited

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 @TiborKaraszi 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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TiborKaraszi avatar image
3 Votes"
TiborKaraszi answered HaithemShaheen-9341 commented

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/

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

this worked thanks

0 Votes 0 ·
Cathyji-msft avatar image
4 Votes"
Cathyji-msft answered Terry-2302 commented

Hi @JimmyWinblad-8183,

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.















· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Cathy - thanks, i went to Lesson 1 as suggested, followed the instructions > expand Database Engine, right click Local server groups and select "Task", and i got the message "No local servers of type 'Database Engine' were found... what can i do then?

0 Votes 0 ·

I've uninstalled and reinstalled everything again (Visual Studio, Management Studio, SQL server) and now it's finally connected...

0 Votes 0 ·

looking in the Computer management path, there is no SQL Configuration Manager option under the Services and Applications drop down.
Does this mean i would need to re-install the whole SSMS?

0 Votes 0 ·
Sophia-1392 avatar image
0 Votes"
Sophia-1392 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.