Hi All I am getting this error in error log Login failed for user ''. The user is not associated with a trusted SQL Server connection Error: 18452, Severity: 14, State: 1 and this when run the executable comes with application [Microsoft][ODBC SQL Server Driver][SQL Server][Login failed for user", The user is not associated with a trusted SQL Server connection
already checked mixed authentication m ode is in use.
I have also found that this error is received when using Windows authentication in the following situations: 1) The client is having issues communicating with the domain controller. 2) Between trusted domains, both networks are having issues communicating back and forth.
If #1 I find a reboot usually addresses the issue (of the client). If this is keeps occuring I suggest you get your network support involved. If #2 I definitely suggest you get your network support involved to resolve the root cause of the issue.
TRY THIS: Start-> RUN -> cliconfg Include NAMED PIPES and TCP/IP into ENABLED Protocols [if not already there] Goto ALIAS TAB - > click on add -> Just write the SERVERNAME in the SERVER ALIAS BOx. Try now... If using MANAGEMENT STUDIO.. do this: In the connect to server window, click on OPTIONS button. and from network protocols choose..Named Pipes and connect...
Maninder Database Painter.. Leaving strokes, that amaze! and inreturn, put value to your Work. I am a Database [Architect / Administrator]