I am new to SQL so bare with me.
I have a VPN user who recieves this error.
"The user is not associated with a trusted SQL Server connection"
The error logs show
"Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 10.1.1.21]"
"SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 10.1.1.21]"
I have a spn problem with an SQL account.
shows only the SID
I am pretty sure if I resolve the sid to name this issue will be resolved.
How do I do this?