SQL windows authentication fails sort of
0
votes
0
answers
35
views
SQLSERVERABC
is on domain abc.local
.
If I connect to SQLSERVERABC via remote desktop, I cannot login to the database via SSMS on the local machine that I have remoted to.
At SSMS login screen:
Server Type: Database Engine Server Name: SQLSERVERABC Authentication: Windows Authentication. User name: abc\myloginThe login attempt will timeout, and the server will not authenticate me or _anyone else_ via Active Directory on our domain controller. The weird thing is Windows Authentication works if I login via SSMS my local computer and not remoted into the SQL server via remote desktop. But we have remote users who are not on our domain (working from home) they have to remote to the SQL Server and can login using Windows Authentication with their domain credentials but only if they substitute the Server Name: SQLSERVERABC with its IP Address on the SSMS login QUI. SQLSERVERABC is set to both windows and SQL server authentication, All DNS instances are set up properly...I can not figure out why Windows Authentication will not work when user remote to the actual SQL box unless we use the box's IP address as its Server Name. Yes it's a work around but need fix it... Trying to get SQL server 2016 that is on a .local domain to allow windows authentication using it's SERVER NAME and not IP address
Asked by James Brewer
(1 rep)
Mar 8, 2024, 05:18 PM
Last activity: Mar 8, 2024, 08:48 PM
Last activity: Mar 8, 2024, 08:48 PM