This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 91%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZH%3C/text%3E%3C/svg%3E)
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:
Can anyone provide sugggestions to get the file SQLServerManager16.msc properly added to my system?
Thanks!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi @Zach Hadjah
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best regards,
Aniya
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 86%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
I think other answerers are missing the point (maybe). I have a similar question. I have SQL Server 2019 installed, but the version of SQL Configuration Manager seems to be out of date. I have seen talk of a version of SQL Configuration Manager with a Certificates tab. Mine doesn't have that. Is there a way to update SQL Configuration Manager? Or should it just come with a SQL Server Service Pack? I would like to have this new certificate management ability.
You are probably looking in the wrong place. To find the Certificate tab, open the node SQL Server Network Configuration. Then right-click the node Protocols for and select Properties. The middle tab is for Certificate.
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?
Thanks for the clarification.
No, i did not install SQL Server, i only installed the SSMS. Will install it now.
Again, thanks for the clarification.
@Zach Hadjah - If the post was useful, mark it an answer and upvote it. This will help other community members with similar queries.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 46%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
@Sreeju Nair Please could you help me out? I am trying to install the SQL server on my hp, but it keeps failing.
House rules: don't piggyback on old threads, but ask a new Question. It helps if you include Summary.txt and Detail.txt.
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.
Adding that even in a workplace with shared SQL instance available, it's not common for SQL developers to install a local instance of Developer Edition. This way, one can perform for development locally and promote changes to shared databases after initial testing . This works will with source control, VS database projects, CI/CD, etc.
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
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?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Right.