How do I Fix Login failed for user ''. for Mac apple silicon download azure SQL Server

Question

've been trying to install azure sql for the past 3 weeks and eep getettign this error message. I deep dived the web for answers but none have suffice. Can you help, I'm trying to use sql for my class and business. I know it's telling em the username I wrong but it's literally the user name I used to run docker and on my laptop. I tried localhost too and that went no where.

Answer 1

as the sqlserver is using a self signed ssl certificate, you need to enable "Trust server certificate" or disable encryption. Once you trust the certificate a login attempt can be made and the name/password will be validated.

Answer 2

Based on the documentation, this error occurs when you try to make an encrypted connection to SQL Server using a non-verifiable certificate. This could happen in the following scenarios:

How to resolve it ?

If you intentionally use either a certificate from a non-trusted authority or a self-signed certificate to encrypt connections to SQL Server, you can use one of the following options:

For scenario 1, add the certificate authority to the Trusted Root Certification Authorities store on the client computer initiating encrypted connection. To do this, complete the Export the server certificate and Install the root certificate authority (CA) on the client machine procedures listed in the next few sections in that sequence.