Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
private1010
Starting Member
15 Posts |
Posted - 2008-07-02 : 02:04:08
|
Hi AllI am getting this error in error logLogin failed for user ''. The user is not associated with a trusted SQL Server connectionError: 18452, Severity: 14, State: 1and 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 connectionalready checked mixed authentication m ode is in use.any help will be appreciated... |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-07-02 : 04:44:09
|
What application? All the message is telling you is that a connection string is not passing the username through, so is therefore failing. |
|
|
mdubey
Posting Yak Master
133 Posts |
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-07-02 : 10:07:55
|
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. |
|
|
contrari4n
Starting Member
27 Posts |
Posted - 2008-07-04 : 17:12:37
|
I have also had this issue. The clue that it is network related is in the fact that the username is null or ''. You may also see a "SSPI handshake failed" error in the logs.A third possible cause is if your network is under a heavy load. When we upgraded our switches from 100Mb to 1GB the problem went away.Richard Fryarhttp://www.sql-server-pro.comSQL Server Articles and Tips |
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-04 : 17:18:17
|
TRY THIS:Start-> RUN -> cliconfgInclude 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...ManinderDatabase Painter.. Leaving strokes, that amaze! and inreturn, put value to your Work. I am a Database [Architect / Administrator] |
|
|
|
|
|