Login Error 18456

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GoodwinM - 24 Mar 2008 19:29 GMT

Using Microsoft Office Accounting 2008, database on SQL Server Express -
Whenever I start the application from a client, an error is entered into the
event log on the server. This does not appear to be causing any issues with
using the application but is obviously annoying.

The event log follows, any assistance is appreciated -

2008-03-19 08:24:30.07 spid51 Starting up database 'MSSmallBusiness'.
2008-03-19 08:24:33.32 Logon Error: 18456, Severity: 14, State: 16.
2008-03-19 08:24:33.32 Logon Login failed for user 'Domain\UserName'.
[CLIENT: 192.168.1.5]
2008-03-19 08:29:59.81 spid8s SQL Server has encountered 1
occurrence(s) of cachestore flush

for the 'Object Plans' cachestore (part of plan cache) due to some database
maintenance or

reconfigure operations.
2008-03-19 08:29:59.82 spid8s SQL Server has encountered 1
occurrence(s) of cachestore flush

for the 'SQL Plans' cachestore (part of plan cache) due to some database
maintenance or

reconfigure operations.
2008-03-19 08:29:59.82 spid8s SQL Server has encountered 1
occurrence(s) of cachestore flush

for the 'Bound Trees' cachestore (part of plan cache) due to some database
maintenance or

reconfigure operations.

Reply to this Message

Ekrem Önsoy - 24 Mar 2008 22:38 GMT

Take a look at this blog and the comments on the same page
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Signature

Ekrem Önsoy

> Using Microsoft Office Accounting 2008, database on SQL Server Express -
> Whenever I start the application from a client, an error is entered into
[quoted text clipped - 32 lines]
>
> reconfigure operations.

Reply to this Message

erwien - 25 Mar 2008 05:22 GMT

> Take a look at this blog and the comments on the same page
> http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

I also had similar issue, the error state is 11, it still did not give
me idea on how to resolve it.

--

Reply to this Message

Ekrem Önsoy - 25 Mar 2008 09:41 GMT

Ensure your SQL Login account has necessary permissions to access to the
server then.

Signature

Ekrem Önsoy

>> Take a look at this blog and the comments on the same page
>> http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
>
> I also had similar issue, the error state is 11, it still did not give
> me idea on how to resolve it.

Reply to this Message

GoodwinM - 25 Mar 2008 19:23 GMT

First - thank you for your response. I am not too familiar with SQL Server.

I have looked at this previously, but it does not seem to address the
problem I am having. If the logon actually did not work, would the
accounting application not fail?

This is not the case, the application appears to work as expected, just the
event is logged, but I can still use the application - adding, changing, and
deleting records. I would think that if the logon is failing, I would not be
able to access the data at all.

> Take a look at this blog and the comments on the same page
> http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
[quoted text clipped - 37 lines]
>>
>> reconfigure operations.

Reply to this Message

Ekrem Önsoy - 25 Mar 2008 23:50 GMT

I don't know about the Microsoft Office Accounting 2008 and I don't know if
it's the accounting application or something else...

But from the log, it seems that someone or an(other?) application is trying
to log in to your SQL Server using Windows Authentication and it fails and
the reason of this failure probably insufficient permissions according to
the error code you typed.

Signature

Ekrem Önsoy

> First - thank you for your response. I am not too familiar with SQL
> Server.
[quoted text clipped - 50 lines]
>>>
>>> reconfigure operations.

Reply to this Message

GoodwinM - 28 Mar 2008 00:17 GMT

Not sure where to go from here.In the event log it indicates the logon
failure, followed within 3 seconds by the cachestore events. The logon
failure indicates it is from the username I am using to start the
application. Again, the application works fine, just the events logging is
annoying and I am sure it means something is not quite right.

>I don't know about the Microsoft Office Accounting 2008 and I don't know if
>it's the accounting application or something else...
[quoted text clipped - 60 lines]
>>>>
>>>> reconfigure operations.

Reply to this Message