error msg Msg 15404
when the message is
Could not obtain information about Windows NT group/user 'SRBSV\jimw', error code 0x6e.
is it an SQL or OS issue.
The same thing on another machine in the same domain, worked fine. so i know the login is good.
Could not obtain information about Windows NT group/user 'SRBSV\jimw', error code 0x6e.
is it an SQL or OS issue.
The same thing on another machine in the same domain, worked fine. so i know the login is good.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> does this mean "BUILTIN\Windows Authorization Access Group" has to be a SQL login as a good practice?
Dropping / Disabling BUILTIN\Local administrators from SQL Server would be good if you would change the administrators in the Server machine more often as this group would by default have sysadmin privileges.
Or in other words, grant the required rights loginwise either Windows login or SQL login.
Hope this clarifies.
Dropping / Disabling BUILTIN\Local administrators from SQL Server would be good if you would change the administrators in the Server machine more often as this group would by default have sysadmin privileges.
Or in other words, grant the required rights loginwise either Windows login or SQL login.
Hope this clarifies.
ASKER
"BUILTIN\Windows Authorization Access Group"
has to be a SQL login as a good practice?