I'm able to login to SQL Server Management Studio using the SQL authentication mode (username: sa) but am unsuccessful with using Active Directory Password Authentication. I have gone on the SQL Server Config Manager and added a domain user and password on the 'log on' section of the SQL Server Properties. When I try to login to SQL using the domain user, I get an error saying:
A connection was successfully established with the server, but then an error occurred during the login process. The certificate chain was issued by an authority that is not trusted.
When logged in with the sa user, I notice that my domain user is in the Logins folder along with the sa account. My troubleshooting so far consists of checking the properties of the domain user file in the Logins folder. In the properties, the box that enables the domain account to login to SQL is checked. Also, the SQL server and AD server are on the domain.
Could I be missing a configuration somewhere? Do I need to assign permission to the domain account for it to be able to access the SQL server and management studio?
This is the dialog box with the error after I try to login using a domain account: