• Register
1 vote
54 views

Problem :

I am very new to Azure. Recently I have started experiencing the error if I try to connect my database which is currently in the VM Role it is the SQL VM Role from the Azure Website. I am experiencing following issue:

SqlException (0x80131904): 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.)]

Can someone kindly help me in fixing above error.

8 5 2
3,230 points

1 Answer

1 vote

Solution :

I have gone through your problem statement and I think you are very inexperienced so you are facing the error. I guess you do not have the CA signed certificate installed on your SQL VM.

And if you already have the Encrypt=True in your connection string in that case you need to set that to off or you can add below line of code in your connection string:

TrustServerCertificate=True

Your SQL Server will automatically create a self-signed certificate if you do not install the signed certificate for it to use but the problem with it is it will not be trusted by your caller as it is not the CA-signed unless you explicitly tell your connection string to trust any of the server cert by default.

8 4
5,680 points

Related questions

0 votes
1 answer 137 views
137 views
Problem : I have a problem in IE9 with the security certificate. When I went to specific address I got below error “There is a problem with this website's security certificate.” How can I avoid the reappearance of this window?
asked Jan 28 jwilliam 3.9k points
0 votes
2 answers 583 views
583 views
Problem : I am facing below listed very strange error. I am using Apache Server. “413. that’s an error. your client issued a request that was too large. that’s all we know.” How can I fix this error?
asked Feb 15 mphil 2.3k points
0 votes
1 answer 773 views
773 views
Problem : I have looked for solution for literally hours but no luck so I am asking it here. I am trying to build the chat server using the python's socket module. But when I run the server after my client connects to it and also the server connects, I ... reduced server and it works where current server does not. This exception has confused me as it is popping up nearly the line for line.
asked Dec 6, 2019 alecxe 7.5k points
0 votes
2 answers 89 views
89 views
Problem : I am new to the SQL. What am I doing wrong here? SELECT LEFT(SUBSTRING(batchinfo.datapath, PATINDEX('%[0-9][0-9][0-9]%', batchinfo.datapath), 8000), PATINDEX('%[^0-9]%', SUBSTRING(batchinfo.datapath, PATINDEX('%[0-9][0-9][0-9]%',batchinfo. ... I am trying to do group by the first, second, and third columns having the max rid. It is works perfectly fine without the group by and having.
asked Nov 27, 2019 alecxe 7.5k points
0 votes
1 answer 44 views
44 views
Problem : I am using two different third party programs those apparently use the Google Maps Javascript API. When they load the map, the world map is shown, but an Error message is displayed as below: you are using a browser that is not supported by the google maps javascript api
asked Oct 19, 2019 peterlaw 6.9k points