|
Home > Archive > MS SQL Server > March 2006 > Login failed for user 'user'. [CLIENT: 10.1.1.51]
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Login failed for user 'user'. [CLIENT: 10.1.1.51]
|
|
| Solomon G 2006-03-07, 1:23 pm |
| Every two weeks or so, I am receiving an error in my application event log
like
Login failed for user 'user'. [CLIENT: 10.1.1.51]
This user is a sql account used for Sharepoint. The password has never
changed. Sharepoint is working before this occurs and works afterwards.I've
never heard from anyone being disconnected from sharepoint. So this error
is a mystery to me. Moreover, the same error and symptoms occur for my
Reporting services account as well. Both Applications reside on different
servers than the SQL Box. The only similarity I can think of is that they
are both web apps. Any ideas on why this is happening?
| |
| John Bell 2006-03-08, 3:23 am |
| Hi
Have you checked the sql server logs to see what they say? It is not clear
if this is a windows or SQL Server user! If windows authenticated then it
could be a problem connecting with authenticating the user in the AD such as
a network problem.
You may want to see if there are any scheduled tasks run at the time this
error occurs.
John
"Solomon G" wrote:
> Every two weeks or so, I am receiving an error in my application event log
> like
>
> Login failed for user 'user'. [CLIENT: 10.1.1.51]
>
> This user is a sql account used for Sharepoint. The password has never
> changed. Sharepoint is working before this occurs and works afterwards.I've
> never heard from anyone being disconnected from sharepoint. So this error
> is a mystery to me. Moreover, the same error and symptoms occur for my
> Reporting services account as well. Both Applications reside on different
> servers than the SQL Box. The only similarity I can think of is that they
> are both web apps. Any ideas on why this is happening?
>
>
>
| |
| Solomon G 2006-03-09, 9:23 am |
| In the SQL Logs, it says
Error 18456 Login failed for user 'user'
Error 17806 SSPI handshake failed with error code 0x8009030c while
establishing a connection with integrated security; the connection has been
closed
Error 18452 Login failed for user '' (that's 2 single quotes). The user
is not associated with a trusted SQL Server connection.
Cool. This provides a little more information. I'll look it up, but if you
know what this could be, by all means, please let me know!
Thanks!
"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:1CCB58F5-854A-431D-BD59- 7BB5F6334BFA@microso
ft.com...[color=darkred]
> Hi
>
> Have you checked the sql server logs to see what they say? It is not clear
> if this is a windows or SQL Server user! If windows authenticated then it
> could be a problem connecting with authenticating the user in the AD such
> as
> a network problem.
>
> You may want to see if there are any scheduled tasks run at the time this
> error occurs.
>
> John
>
> "Solomon G" wrote:
>
| |
| John Bell 2006-03-09, 1:23 pm |
| Hi
If you have not seen these you may want to try them
http://tinyurl.com/ro4b6
http://tinyurl.com/9ha68
You may also want to check windows service packs and/or monitor your network.
John
"Solomon G" wrote:
> In the SQL Logs, it says
>
> Error 18456 Login failed for user 'user'
> Error 17806 SSPI handshake failed with error code 0x8009030c while
> establishing a connection with integrated security; the connection has been
> closed
> Error 18452 Login failed for user '' (that's 2 single quotes). The user
> is not associated with a trusted SQL Server connection.
>
> Cool. This provides a little more information. I'll look it up, but if you
> know what this could be, by all means, please let me know!
>
> Thanks!
>
>
> "John Bell" < jbellnewsposts@hotma
il.com> wrote in message
> news:1CCB58F5-854A-431D-BD59- 7BB5F6334BFA@microso
ft.com...
>
>
>
|
|
|
|
|