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

Рет қаралды 2,128

2 ай бұрын

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/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/microsoft-powerpiv...
----
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/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): idodata.com/database-fundament...
SQL Server Essential in an Hour: idodata.com/sql-server-essenti...
70-462 SQL Server Database Administration (DBA): idodata.com/sql-server-databas...
DP-300: Administering Relational Databases: idodata.com/dp-300-administeri...
Microsoft SQL Server Reporting Services (SSRS): idodata.com/microsoft-sql-serv...
SQL Server Integration Services (SSIS): idodata.com/sql-server-integra...
SQL Server Analysis Services (SSAS): idodata.com/sql-server-ssas-mu...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/microsoft-powerpiv...
1Z0-071 Oracle SQL Developer - certified associate: idodata.com/iz0-071-oracle-sql...
SQL for Microsoft Access: idodata.com/sql-for-microsoft-...
DP-900: Microsoft Azure Data Fundamentals: idodata.com/dp-900-microsoft-a...

Пікірлер: 8

@TheTomBrookes

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

@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?

@nocturnetheatre3954 14 сағат бұрын

thank you!

@krunaljha9582 14 күн бұрын

Thank you

@Palash_Kundu

Thank you man.

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