How to download Sql Server Configuration Manager

Zach Hadjah 21 Reputation points
2022-09-25T07:02:10.793+00:00

Hello,

BRAND NEW to SQL Server. I was following along with a tutorial and downloaded the SSMS, however, doesn't seem like i have the configuration manager installed properly. I tried entering the credentials first prompted once SSMS was done downloading only to realize the configuration manager doesn't even appear.

I took a look at the doc that told me to head to the file location (im using windows 11) and I'm currently not seeing the files there:

https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?redirectedfrom=MSDN&view=sql-server-ver16

244460-image.png

Can anyone provide sugggestions to get the file SQLServerManager16.msc properly added to my system?

Thanks!

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,891 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,824 questions
{count} votes

5 answers

Sort by: Most helpful
  1. Sreeju Nair 11,776 Reputation points
    2022-09-25T07:16:02.01+00:00

    SQL Configuration Manager is not part of SSMS, Configuration Manager is iis installed with SQL Server, so either you install SQL Server. It is a Management Console snap-in. Based on the description you installed SSMS, do you have SQL Server installed in the same machine?

    2 people found this answer helpful.

  2. Erland Sommarskog 102.3K Reputation points
    2022-09-25T09:26:38.96+00:00

    SSMS is only a UI tool to communicate with SQL Server. On its own, you can not achieve much with SSMS.

    In the situation where you are in a workplace as a developer, there is often a development server with SQL Server installed, and you don't SQL Server on your own machine.

    However, since you are brand-new, I assume that you are working on your private laptop, and in this case you would download and install SQL Server on your laptop. And, as sreejukg says, when you install SQL Server, you will also get the SQL Server Configuration Manager.

    You can download SQL Server 2019 here: https://go.microsoft.com/fwlink/p/?linkid=866662.

    Once you have installed it, you should apply the most recent Cumulative Update to get access to bug fixes and minor improvements.


  3. AniyaTang-MSFT 12,326 Reputation points Microsoft Vendor
    2022-09-26T01:30:33.007+00:00

    Hi @Zach Hadjah
    SQL Server Configuration Manager is part of SQL Server, it is installed with your SQL Server installation. For more details about it, you can refer to this link: sql-server-configuration-manager.
    SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. It is a tool separate from SQL Server. So if you want to use SQL Server Configuration Manager, please download the appropriate version of SQL Server.
    Here is the download link about SQL Server: sql-server-downloads.
    Best regards,
    Aniya

    0 comments No comments

  4. Olaf Helper 41,331 Reputation points
    2022-09-26T05:13:52.303+00:00

    No, i did not install SQL Server

    SSCM = "SQL Server Configuration Manager" is to manage SQL Server seting like network conectivity and so on.
    You haven't installed SQL Server engine, so what would it be good for to have SSCM installed; there is nothing you could manage with?

    0 comments No comments

  5. Anonymous
    2023-03-03T01:08:32.35+00:00

    Right.

    • Log onto the server.
    • Click the windows logo in the bottom left corner.
    • Type S-Q-L S-e-r etc.
    • The desktop app should appear in the list.
    • Right-click and "Open File Location".
    • C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2019\Configuration Tools That's where I find it, your location may differ. Also I have assumed Windows. SQL
    0 comments No comments