I'm struggling couple of days with the following issue.
I'm want to let people, that are a member of a AD authentication with their username/password on SQL Management Studio 17.x but I cannot use Windows Authentication, because the computer they are working on is not joined in the domain.
There is a option for "Active Directory - password". I had the issue that my certificate was not trusted. That has been solved, but now I get he message; OR: Target principal name not found/incorrect OR: Login failed for user .
My SQL-servers are configured in Mixed-mode.
Hope somebody can help me, because now my remote users, cannot login onto SQL with their own AD credentials.
BTW, I do see allot of solution to use batch-file to launch it, but I'm hoping that there is another way because in that case, the credentials are still plain text on that workstation.
Best regards Dave