ERROR 18456 not being logged in event viewer

Hi.
I made an alert that will email me whenever someone causes error 18456 to be
raised... My thinking behind this is that if anyones trying to access my
server and FAILS, then they are probably up to no good.
So anyway... This alert was created... I verified that SQL Server Agent
Mail is running, as is SQL Mail... so thats not the point of failure.
I just attempted to log in with sa and a fake password. It predictably did
not give me access to the databases, but the event was NOT logged to the
application log. I checked in enterprise manager, and the checkbox that
says "Always write to Windows eventlog" is checked.
I also verified that the SQL Server Agent is running under a local and
domain admin, and this is the case.
Does anybody have any ideas?
Thanks in advance,
-- Jason
I assume that this error number is failed login. If so, you handle this in a special way. EM, right-click your
server, security.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jeigh" <folkens.jason@.acd.net> wrote in message news:CoydnaIo9LfTcVndRVn-gw@.giganews.com...
> Hi.
> I made an alert that will email me whenever someone causes error 18456 to be
> raised... My thinking behind this is that if anyones trying to access my
> server and FAILS, then they are probably up to no good.
> So anyway... This alert was created... I verified that SQL Server Agent
> Mail is running, as is SQL Mail... so thats not the point of failure.
> I just attempted to log in with sa and a fake password. It predictably did
> not give me access to the databases, but the event was NOT logged to the
> application log. I checked in enterprise manager, and the checkbox that
> says "Always write to Windows eventlog" is checked.
> I also verified that the SQL Server Agent is running under a local and
> domain admin, and this is the case.
> Does anybody have any ideas?
> Thanks in advance,
> -- Jason
>
|||Are you referring to the "Audit Level" raido buttons?
Changing it from "None" to "Failure" didnt seem to make that much of a
difference. Am I looking at the right thing?
Thanks,
-- Jason
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O6NBB4STEHA.2416@.TK2MSFTNGP09.phx.gbl...
> I assume that this error number is failed login. If so, you handle this in
a special way. EM, right-click your
> server, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Jeigh" <folkens.jason@.acd.net> wrote in message
news:CoydnaIo9LfTcVndRVn-gw@.giganews.com...[vbcol=seagreen]
to be[vbcol=seagreen]
my[vbcol=seagreen]
Agent[vbcol=seagreen]
did
>
|||Yep, that's the one I was referring to. So you don't see the events logged to eventlog, after checking the
checkbox. Strange, I know it work for me. Perhaps time to open a case with MS?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jeigh" <folkens.jason@.acd.net> wrote in message news:p7GdnZI30-avWFjd4p2dnA@.giganews.com...
> Are you referring to the "Audit Level" raido buttons?
> Changing it from "None" to "Failure" didnt seem to make that much of a
> difference. Am I looking at the right thing?
> Thanks,
> -- Jason
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:O6NBB4STEHA.2416@.TK2MSFTNGP09.phx.gbl...
> a special way. EM, right-click your
> news:CoydnaIo9LfTcVndRVn-gw@.giganews.com...
> to be
> my
> Agent
> did
>

Error 14258: ... SQL ServerAgent is starting

Whenever I attempt to edit/run/... a scheduled job, I get the error message:
"Error 14258: Cannot perform this operation while SQL ServerAgent is
starting. Try again later."
I also notice that all scheduled jobs have "Date/time not available" in
"Next Run Date".
Of course Agent is not starting now, it has already started (Alerts and
Operators can be edited without a problem). The server is SQL2000, SP4.
Check the status of the service from Administrative Tools -
is the service Running or Starting?
Alerts and operators can be edited without Agent running.
Also check your Agent.out file.
-Sue
On Thu, 16 Feb 2006 03:55:29 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:

>Whenever I attempt to edit/run/... a scheduled job, I get the error message:
>"Error 14258: Cannot perform this operation while SQL ServerAgent is
>starting. Try again later."
>I also notice that all scheduled jobs have "Date/time not available" in
>"Next Run Date".
>Of course Agent is not starting now, it has already started (Alerts and
>Operators can be edited without a problem). The server is SQL2000, SP4.
|||The service IS running. I restarted it to make sure though, as I also did
with the server and the machine; nothing worked. The service is reported to
be running in both enterprise manager and windows services but no scheduled
jobs can be edited/run/...etc.
Also, when I stop the service I can edit jobs or create new ones, but there
is no way to run them.
There is no Agent.out file.
"Sue Hoegemeier" wrote:

> Check the status of the service from Administrative Tools -
> is the service Running or Starting?
> Alerts and operators can be edited without Agent running.
> Also check your Agent.out file.
> -Sue
|||ok, I checked SQLAgent.out file. It has one entry:
"... ? [393] Waiting for SQL Server to recover databases..."
but I don't understand which databases it is recovering as there is no such
indication in SQL server logs or Current activity.
"Sue Hoegemeier" wrote:

> Check the status of the service from Administrative Tools -
> is the service Running or Starting?
> Alerts and operators can be edited without Agent running.
> Also check your Agent.out file.
> -Sue
|||If you tried stopping and then restarting just the Agent
service and it won't start, reporting the same error then my
guess would be that you are running SQL Server in
lightweight pooling mode. Set it back to the default of
thread mode.
sp_configure 'allow updates', 1
go
reconfigure with override
go
sp_configure 'lightweight pooling', 0
go
reconfigure with override
go
-Sue
On Fri, 17 Feb 2006 00:41:28 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>ok, I checked SQLAgent.out file. It has one entry:
>"... ? [393] Waiting for SQL Server to recover databases..."
>but I don't understand which databases it is recovering as there is no such
>indication in SQL server logs or Current activity.
>
>"Sue Hoegemeier" wrote:

Error 14258

For the last two days I've been getting this error whenever I click on a Job
in Enterprise Manager:
Error 14258: Cannot perform this operation while SQLServerAgent is starting.
Try again later.
Any idea what is causing this? Agent appears to be running - it is
performing the assigned tasks on schedule.
I am also have a ongoing issue with this problem. Where you able to find
the root cause of this issue? Please let me know, as we are in bad need
of a solution to this problem.
Reply to thovorka@.quickutz.com
Thanks,
Todd
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Error 14258

For the last two days I've been getting this error whenever I click on a Job
in Enterprise Manager:
Error 14258: Cannot perform this operation while SQLServerAgent is starting.
Try again later.
Any idea what is causing this? Agent appears to be running - it is
performing the assigned tasks on schedule.I am also have a ongoing issue with this problem. Where you able to find
the root cause of this issue? Please let me know, as we are in bad need
of a solution to this problem.
Reply to thovorka@.quickutz.com
Thanks,
Todd
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Error 14258

For the last two days I've been getting this error whenever I click on a Job
in Enterprise Manager:
Error 14258: Cannot perform this operation while SQLServerAgent is starting.
Try again later.
Any idea what is causing this? Agent appears to be running - it is
performing the assigned tasks on schedule.Hi,
The SQLServerAgent has NOT started properly after a
shutdown/reboot two days ago. If you look at the service
manager, the service appears to have started, but its
really not.
Here is what you have to do:
Stop the SQLServerAgent (Not SQL Server)
Restart the service (make no errors are recorded)
Here is something else you may have not noticed, since
this error has been occurring, your scheduled jobs have
not run. You might want to backup your databases and run
any other jobs you may have.
hth
DeeJay
>--Original Message--
>For the last two days I've been getting this error
whenever I click on a Job
>in Enterprise Manager:
>Error 14258: Cannot perform this operation while
SQLServerAgent is starting.
>Try again later.
>Any idea what is causing this? Agent appears to be
running - it is
>performing the assigned tasks on schedule.
>
>.
>|||OK I've stopped and restarted the service several times. Event Viewer claims
the service started succesfully. Where else can I look for errors? The SQL
Server logs show no errors with the Agent. But you are correct - the jobs
are NOT running! Any other sugggestions on where to look for the problem?
"DeeJay Puar" <deejaypuar@.Yahoo.com> wrote in message
news:393601c48f89$d0181ff0$a501280a@.phx.gbl...
> Hi,
> The SQLServerAgent has NOT started properly after a
> shutdown/reboot two days ago. If you look at the service
> manager, the service appears to have started, but its
> really not.
> Here is what you have to do:
> Stop the SQLServerAgent (Not SQL Server)
> Restart the service (make no errors are recorded)
> Here is something else you may have not noticed, since
> this error has been occurring, your scheduled jobs have
> not run. You might want to backup your databases and run
> any other jobs you may have.
> hth
> DeeJay
> >--Original Message--
> >For the last two days I've been getting this error
> whenever I click on a Job
> >in Enterprise Manager:
> >
> >Error 14258: Cannot perform this operation while
> SQLServerAgent is starting.
> >Try again later.
> >
> >Any idea what is causing this? Agent appears to be
> running - it is
> >performing the assigned tasks on schedule.
> >
> >
> >.
> >|||I am also have a ongoing issue with this problem. Where you able to find
the root cause of this issue? Please let me know, as we are in bad need
of a solution to this problem.
Reply to thovorka@.quickutz.com
Thanks,
Todd
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!