sometime while connecting to the database server using SSMS you get below error.
Issue:-
TITLE: Connect to Server
------------------------------
Cannot connect to 4X.6X.1X8.2X1,1433.
------------------------------
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: http://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
------------------------------
Problem:-
Resolution:- In order to resolve this issue.
Method 1:-
If You are trying to access it through Data Connections in Visual Studio 2015, and getting the above Error, Then Go to Advanced and set TrustServerCertificate=True for error to go away.
Method 2:-
If You are trying to access it through SSMS, and getting the above Error, Then Go to Advanced and set TrustServerCertificate=True for error to go away.
Method 3:-
If you're using SQL Management Studio, please goto connection properties and click on "Trust server certificated"
