Installing SSMS version 20, and solving certificate chain not trusted problem in SQL Server.

In this video, we will look at the major changes that have happened with the release of SQL Server Management Studio (SSMS) version 20.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/que...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/dat...
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql...
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql...
SQL Server Integration Services (SSIS): rebrand.ly/sql...
SQL Server Analysis Services (SSAS): rebrand.ly/sql...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
----
SSMS version 20 was released in March 2024. However, there are 2 major changes.
1. If you connect to your local server, then by default you will get the following error message:
A connection was successfully established with the server, but then an error occurred during the login process. The certificate chain was issued by an authority that is not trusted.
If you are connecting to a local machine, then you have two choices:
a. Change the Encryption to Optional, or
b. Check "Trust server certificate".
2. Azure Data Studio is not installed by default. If you want it, you will need to install it separately.
----
Links to my website are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: idodata.com/que...
98-364: Database Fundamentals (Microsoft SQL Server): idodata.com/dat...
SQL Server Essential in an Hour: idodata.com/sql...
70-462 SQL Server Database Administration (DBA): idodata.com/sql...
DP-300: Administering Relational Databases: idodata.com/dp-...
Microsoft SQL Server Reporting Services (SSRS): idodata.com/mic...
SQL Server Integration Services (SSIS): idodata.com/sql...
SQL Server Analysis Services (SSAS): idodata.com/sql...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
1Z0-071 Oracle SQL Developer - certified associate: idodata.com/iz0...
SQL for Microsoft Access: idodata.com/sql...
DP-900: Microsoft Azure Data Fundamentals: idodata.com/dp-...

[@TheTomBrookes]

Thank you, I feel stupid not seeing this option previously!

[@SQLServer101]

Hi Tom. Don't fool stupid - it isn't an obvious setting. You do have to know it is there, and Microsoft could have done a much better of highlighting the changes. Phillip

[@Palash_Kundu]

Thank you man.

[@nocturnetheatre3954]

thank you!

[@krunaljha9582]

Thank you

[@DannyFerri]

This is great. While many of the options you described i already knew, what I didnt know was that SQL 2022 creates a self-signed cert by default. that explains the issue that I'm having. however, what i would like to know is cant we export the Self-signed SQL cert and add it to the trusted certs?

[@SQLServer101]

Hello Danny. Thank you for your question. Please see stackoverflow.com/questions/65836055/self-signed-certificate-cant-get-sql-server-client-to-trust-it . Phillip

[@emrah_saglam]

Long explanation but there is no information for the disabling encryption. If you using CMS you coulnt make that setting one by one. You should disable encrytipn on Regedit.exe or etc.

[@JorgeJaramaReategui]

doesnt work for me

[@SQLServer101]

Hi Jorge. Why doesn't it work for you? Phillip