Sample Header Ad - 728x90

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\mylogin
The 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