Unable to download SQL server management studio 19.0.2 on windows 11

Isna Darmuis 20

Hello. I'm unable to install SQL Server Management Studio 19.0.2 on my new fresh intalled windows 11 but I have no problem to install/download SQL server 2022. It's a personal computer and installed McAfee. Tried to uninstall McAfee but it said if uninstall I will loose my 1yr subscription. The computer meets the requirement: intel core i7, 16GB memory,512GB SSD. SSMS already appeared on the system but still I can't open it. I did uninstall and try to reinstall it but doesn't work. Some of the components are still there. Unable to remove them. Please help. Thank you in advance.

Erland Sommarskog 107.2K Reputation points

2023-04-24T20:36:06.6933333+00:00

So what actually happens? Do you get an error message?

You say you cannot download, but then you talk about uninstall. How can you uninstall something you cannot download?
Isna Darmuis 20 Reputation points

2023-04-24T22:45:05.2566667+00:00

Hi Erland, thanks for your response. Sorry, I mean I can download and have problem during the installation. After the installation done, SSMS doesn't show up automatically and I have to search on the apps list (screenshot A)Screenshot A.png. I click SQL SMS19 (screenshot B)Screenshot B.png. I click on Database Engine, choose one of them (screenshot C)Screenshot C.png. At the end Screenshot D.png. I did try click these (ANS1 SQLEXPRESS, 1,2,3) and the result still the same like on screenshot D. On screenshot D it said a connection succesfully establish with the server but have a problem with the certificate chain was issued by an authority that is not trusted. What does it mean? The installation for SQL server and SSMS 19 are suppose to be easy right? just follow the instructions? or is that how it usually? After using mac for ages and decided back to windows to learn SQL, It's kind of frustrated though. Thanks.
Isna Darmuis 20 Reputation points

2023-04-24T23:32:59.6633333+00:00

Hi Erland, thanks for your response. I have problem during installation. It seems not common. After finished the installation, the SSMS19 didn't turn up automatically open and I have to search on the apps list (screenshot A)

I click SSMS19 and I have to browse to find a server name (screenshot B).

I try and click on Database engine ANS1\SQLEXPRESS, or 1,2,3 (screenshotC)

It result is the same like on the screenshot D.

It said the connections is succesfully established with the server but has a problem with certificate chain was issued by an authority that's not trusted. What does it mean? The installation SQL server and SSMS19 are supposed to be easy right just follow the instructions? is that common always like this? is there something else I missed? After using mac for ages and want to learn SQL by using windows, it's kind of frustrated for me. Thanks.
Erland Sommarskog 107.2K Reputation points

2023-04-25T20:00:01.6266667+00:00

It is a little odd so far that with a default installation of SSMS you are not supposed to get that error. Yet. That is, Microsoft have made changes to all their client APIs to require an encrypted connection by a trusted certificate by default. This change has propagated to Azure Data Studio, but not to yet to SSMS, but it will come.

Yes, it is supposed to be simple , but "simple" and "security" does not always walk hand in hand. Say that you connect to a server with sensitive data. What could happen is that someone tricks the network so that when you think that you connect to SQL Server, you connect to the attacker's SQL-Server-lookalike which sends your queries further to SQL Server, and returns the data - but also logs the statements and data to the attacker's own data store. This is known as a man-in-the-middle attack. If you have a certificate which you have gotten from a trustworthy source, for instance your DBA, you can install it your trusted certificate store, the attack will not work, because connection will fail when you don't trust the certificate.

On the other hand, checking Trust Server Certificate means "I trust the man-in-the-middle".

Of course, in many situations this man-in-the-middle is completely hypothetic. For instance in the trivial case when you run SQL Server and SSMS on the same machine. Or you work in a test environment with no real data. You may say "I'm in a corporate environment and we are all behind firewall". No no, the man-in-the-middle can be someone from within, for instance a network guy that work extra as a data thief.
Isna Darmuis 20 Reputation points

2023-04-25T21:32:27.59+00:00

Hi Erland, For a newbie SQL like me it's quite confusing. I thought I already have followed the instructions. I have no idea that I have to go to connection properties to click trust server certificate and Encrypt connection. Again, thank you Erland.
Erland Sommarskog 107.2K Reputation points

2023-04-26T20:38:55.1766667+00:00

And that's the mysterious thing. Normally, there is no need to do this. Maybe you accidentally checked the Encrypted checkbox and that gave you problem.

Accepted answer

AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor

2023-04-25T06:10:25.2566667+00:00

Hi @Isna Darmuis

According to your screenshot, it seems that your SSMS has been downloaded successfully, but an error occurred when connecting to the database.

Depending on your error message, you might not have a CA-signed certificate installed in SQL's trusted root store. However, if you only want to trust the server's self-signed certificate, you can try ticking "Trust server certificate". Of course, the best solution is to deal with certificate trust issues.

For more details, you can refer to this link: https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn.

Best regards,

Aniya
Please sign in to rate this answer.

1 person found this answer helpful.
Isna Darmuis 20 Reputation points

2023-04-25T18:24:22.0866667+00:00

Hi @AniyaTang-MSFT Thank you so much for your info. It works! I hope there is no more problem. Again, thank you! Kind Regards, Isna
Sign in to comment

Share via

Unable to download SQL server management studio 19.0.2 on windows 11

0 additional answers