Can't start SQLServerAgent

All of sudden, getting a Dr. Waston error with illegal
instruction on boot up.
If I tried to start it from the Services menu, get "Could
not start the SQLServerAgent service on \\server_name
Error 1067: The process terminated unexpectedly"
Do I need to reload the software... I have not found any
help in the Knowledge baseTake a closer look at the Dr Watson log to see if the SQLAgent service is
generating the Dr Watson error.
Stop any unnessary services on the machine. Leave the following running:
- Alerter
- Computer Browser
- Event Log
- License Logging Service
- Messenger
- Net Logon
- NTLM Security Support Provider
- Network Connectors
- Plug and Play
- Remote Procedure Call (RPC) Locator
- Remote Procedure Call (RPC) Service
- Server
- Spooler
- TCP/IP NetBIOS Helper
- Time Service
- Workstation
Review the NT application & System logs for hardware failure errors.
Test to see if you can start SQL Server from a command prompt.
If the problem persists and you're on the latest service pack, sp3, then
you should open up a support case.
If the Dr Watson is being caused by a bug in our product you will not be
charged for the incident.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can't start SQLServerAgent

All of sudden, getting a Dr. Waston error with illegal
instruction on boot up.
If I tried to start it from the Services menu, get "Could
not start the SQLServerAgent service on \\server_name
Error 1067: The process terminated unexpectedly"
Do I need to reload the software... I have not found any
help in the Knowledge base| All of sudden, getting a Dr. Waston error with illegal
| instruction on boot up.
|
| If I tried to start it from the Services menu, get "Could
| not start the SQLServerAgent service on \\server_name
| Error 1067: The process terminated unexpectedly"
|
| Do I need to reload the software... I have not found any
| help in the Knowledge base
--
Folks,
If you can't find references of a SQL exception, please log a case with
Microsoft product support. There is a chance that this a bug so the case
shouldn't cost you.
Hope this helps,
--
Eric Cárdenas
SQL Server support|||Eric,
Thanks for the response... How do I log a case with
Microsoft product support?|||| Eric,
|
| Thanks for the response... How do I log a case with
| Microsoft product support?
|
--
Go to http://support.microsoft.com to get the contact number of Microsoft
product support for your country of residence.
Hope this helps,
--
Eric Cárdenas
SQL Server support

can't post replies to messages

I'm having issues trying to post replies to messages in this newsgroup all of a sudden, anyone else having an issue?
when I click on post I get the "we're sorry we did not receive your post please try again later" message.
grrrrrrrrrrrrr...!
Use a newsreader.
http://www.aspfaq.com/5007
http://www.aspfaq.com/
(Reverse address to reply.)
"bill_the_cat" <billthecat@.discussions.microsoft.com> wrote in message
news:76D261C5-829E-44C1-B9C3-30C82D175FEA@.microsoft.com...
> I'm having issues trying to post replies to messages in this newsgroup all
of a sudden, anyone else having an issue?
> when I click on post I get the "we're sorry we did not receive your post
please try again later" message.
> grrrrrrrrrrrrr...!
|||thks for the url..looks interesting. In checking my original thread I now see my posts were posted.
So I'm getting "false negatives" of the errors that my posts are not being received.
bill
"Aaron [SQL Server MVP]" wrote:

> Use a newsreader.
> http://www.aspfaq.com/5007
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "bill_the_cat" <billthecat@.discussions.microsoft.com> wrote in message
> news:76D261C5-829E-44C1-B9C3-30C82D175FEA@.microsoft.com...
> of a sudden, anyone else having an issue?
> please try again later" message.
>
>

can't post replies to messages

I'm having issues trying to post replies to messages in this newsgroup all o
f a sudden, anyone else having an issue?
when I click on post I get the "we're sorry we did not receive your post ple
ase try again later" message.
grrrrrrrrrrrrr...!Use a newsreader.
http://www.aspfaq.com/5007
http://www.aspfaq.com/
(Reverse address to reply.)
"bill_the_cat" <billthecat@.discussions.microsoft.com> wrote in message
news:76D261C5-829E-44C1-B9C3-30C82D175FEA@.microsoft.com...
> I'm having issues trying to post replies to messages in this newsgroup all
of a sudden, anyone else having an issue?
> when I click on post I get the "we're sorry we did not receive your post
please try again later" message.
> grrrrrrrrrrrrr...!|||thks for the url..looks interesting. In checking my original thread I now s
ee my posts were posted.
So I'm getting "false negatives" of the errors that my posts are not being r
eceived.
bill
"Aaron [SQL Server MVP]" wrote:

> Use a newsreader.
> http://www.aspfaq.com/5007
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "bill_the_cat" <billthecat@.discussions.microsoft.com> wrote in message
> news:76D261C5-829E-44C1-B9C3-30C82D175FEA@.microsoft.com...
> of a sudden, anyone else having an issue?
> please try again later" message.
>
>

Can't log in as sa

SQL Server 2005

All of a sudden we cannot log in using sa. The "enforce expiration"
option is not set.
How could this have happened outside of a user deliberately changing
the password? Can sa get
locked out for other reasons?

Bill E.
Hollywood, FL"Bill E." <billmiami2@.netscape.netwrote in message
news:1189503759.466560.270090@.y42g2000hsy.googlegr oups.com...

Quote:

Originally Posted by

SQL Server 2005
>
All of a sudden we cannot log in using sa. The "enforce expiration"
option is not set.
How could this have happened outside of a user deliberately changing
the password? Can sa get
locked out for other reasons?

Not that I'm aware of.

Sounds like someone changed the sa password or you've got a bad case of
fat-fingering.

Worse case, I'd start looking for domain accounts and the like that didn't
exist before. (A typical 'first thing' a hacker would do.)

Quote:

Originally Posted by

>
Bill E.
Hollywood, FL
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Thanks Greg.

This SQL Server is behind the firewall--not available outside the
corporate network. However, when I get a chance I'll follow your
suggestion.

Bill|||"Bill E." <billmiami2@.netscape.netwrote in message
news:1189514657.397892.140570@.k79g2000hse.googlegr oups.com...

Quote:

Originally Posted by

Thanks Greg.
>
This SQL Server is behind the firewall--not available outside the
corporate network. However, when I get a chance I'll follow your
suggestion.
>

It's probably an innocent screw up then.

But you never know. (Besides, not all hackers come from outside a company
unfortunately.)

Quote:

Originally Posted by

Bill
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||If the server authentication mode was changed to Windows
Authentication only sa would no longer work.

Roy Harvey
Beacon Falls, CT

On Tue, 11 Sep 2007 02:42:39 -0700, "Bill E."
<billmiami2@.netscape.netwrote:

Quote:

Originally Posted by

>SQL Server 2005
>
>All of a sudden we cannot log in using sa. The "enforce expiration"
>option is not set.
>How could this have happened outside of a user deliberately changing
>the password? Can sa get
>locked out for other reasons?
>
>Bill E.
>Hollywood, FL

|||No, it's still set to mixed mode and I'm using other logins for
applications.

Bill