AD groups authentication doesn't work at the console of SQL Server 2017
0
votes
0
answers
54
views
I come up with this. A Domain admin windows user is able to login to a SQL Server 2017 instance from any client computer, but it can not login from the console of the server. TCP/IP and Shared memory protocols are enabled and the "Domain admins" group is added as well as a sysadmin.
In order to login from the console I ended up adding the specific domain admin user to workaround the problem at the console but why the same windows user can login from outside the server but it can not do that at the console through AD groups?
Asked by Roman Peralta
(31 rep)
Jun 14, 2020, 10:37 PM
Last activity: Jun 15, 2020, 05:18 AM
Last activity: Jun 15, 2020, 05:18 AM