Re: Login Error 18456
- From: "GoodwinM" <mitchgoodwin@xxxxxxxxxxx>
- Date: Thu, 27 Mar 2008 19:17:48 -0400
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.
"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:8B418429-EB69-425F-8143-A7A8E11F86BA@xxxxxxxxxxxxxxxx
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.
--
Ekrem Önsoy
"GoodwinM" <mitchgoodwin@xxxxxxxxxxx> wrote in message
news:e3lIXVqjIHA.4664@xxxxxxxxxxxxxxxxxxxxxxx
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.
"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:41190796-D57E-4F6F-9548-126E95F38F87@xxxxxxxxxxxxxxxx
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
--
Ekrem Önsoy
"GoodwinM" <mitchgoodwin@xxxxxxxxxxx> wrote in message
news:u1dY%23zdjIHA.4244@xxxxxxxxxxxxxxxxxxxxxxx
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.
.
- References:
- Login Error 18456
- From: GoodwinM
- Re: Login Error 18456
- From: Ekrem Önsoy
- Re: Login Error 18456
- From: GoodwinM
- Re: Login Error 18456
- From: Ekrem Önsoy
- Login Error 18456
- Prev by Date: RE: What tools do you use to comply with Sarbanes-Oxley?
- Next by Date: Re: Creating new user default to DB_owner role
- Previous by thread: Re: Login Error 18456
- Next by thread: Stored Proc security
- Index(es):
Relevant Pages
|
|
