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?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.