In this guide, we will attempt to bypass the error shown when trying to connect to Microsoft SQL Server using SQL Server Management Studio (SSMS) v19.
Symptoms
When connecting to Microsoft SQL Server using SSMS version 19.0.0 and above, the following error shows up:
.png?version=2&modificationDate=1683795709468&cacheVersion=1&api=v2&width=566&height=280)
Solution
Click on Options >>, the Connect to Server menu will be expanded. Click on the Connection Properties tab. The following is what you will see:
.png?version=1&modificationDate=1683795835295&cacheVersion=1&api=v2&width=453&height=479)
There are two solutions available:
Uncheck Encrypt connection
Check Trust server certificate
After performing either one of the step above, click Connect. You will connect to the SQL Server successfully.