I launched SQL Server Management, Visual Studio after installation and selected that it should access local SQL server on my terminal. The error message is that the certificate chain was issued by an authority that was not trusted. Please see the attached. Kindly assist with guidance here.
LuxGBeginner
Visual Studio error when launched to access local SQL server installed on my desktop
Share
TITLE: Error
——————————
Encryption was enabled on this connection, review your SSL and certificate configuration for the target SQL Server, or enable ‘Trust server certificate’ in the connection dialog”
For help, click: https://aka.ms/ssdt
——————————
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server, Error: -2146893019)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-2146893019&LinkId=20476
——————————
The certificate chain was issued by an authority that is not trusted
——————————
BUTTONS:
OK
——————————
You need to check the Trusted Server Certificate
Check this