May 26, 2016 at 4:52 pm
Hi,
Can anyone help me, please? I'm trying to set up a home lab using VMware and I'm having trouble with this error:
The certificate chain was issued by an authority that is not trusted
So, I have a DC installed on a VM and another VM with 2 SQL instances. I was planning to install Management Studio on the host machine and connect to the SQL instances installed on the VMs. Everytime I try to connect to the instances using Management Studio using the authentication method: "active directory password authentication" and providing the user and pw, I'm getting this message:
A connection was successfully established with the server, but then an error ocurred during the login process (provider: SSL Provider, error: 0 - The certificate was issued by an authority that is not trusted) (Microsoft SQL Server)
I'm using the admin user that I created on the DC to login to those instances. DOMAIN\administrator.
Options from the configuration manager:
SQL Server network configuration
Force Encryption = No
Hide Instance = No
SQL Native Client 11.0 Configuration
Force Protocol Encryption = no
Trust Server Certificate = no
Thank you!
May 31, 2016 at 3:02 pm
have you successfully joined the machine to the domain?
Can you provide a little more detail at all?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2016 at 4:56 am
Hi,
The VM with those 2 SQL instances are on the domain.
I changed the authentication method on these 2 instances to mixed mode.
Now, I can successfully connect to the instances using SQL Authentication, via SSMS on the host machine.
The host machine isn't on the domain... I was wondering if that's why I was getting that error.
I found this post about "Connect to SQL Servers in another domain using Windows Authentication".
Is this going to help me?
Thank you!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply