• Register
1 vote

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

Please log in or register to answer this question.

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:


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 309 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, 2020 jwilliam 3.9k points
0 votes
2 answers 1.5K 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, 2020 mphil 2.3k points
0 votes
1 answer 1.6K 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 134 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 12 views
Problem : Excel & visual Basic Error "The subject is not trusted for specified action"
asked Feb 18 Shovo210 2.3k points
0 votes
1 answer 147 views
Problem : I am facing below error “System.security.securityexception: that assembly does not allow partially trusted callers.” Is it possible to make my Library to allow partially trusted callers?
asked Feb 17, 2020 mphil 2.3k points
0 votes
1 answer 61 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
0 votes
1 answer 343 views
Problem: I have only fundamental knowledge on node.js, nodemailer. Now a days I am working on this app it is in Node.js with the express and I also have this error as shown below: Error: self signed certificate in certificate chain. at Error (native)     at TLSSocket.< ... - ms - - I have already changed the mail service and also tried to disable my antivirus but still I am facing the same error.
asked Jul 28, 2020 Raphael Pacheco 4.9k points