chuggin, I know it's an old post but I hope you're still around.

I want to set up database mail. I have SQL Server 2008 running on Windows Server 2008...

If I were you I would for sure look over Brent Ozar's website: SQL Serverpedia and view some videos that cover performance monitoring. EG:

http://sqlserverpedia.com/search/?search=performance+monitoring

There are three...

henners72 (6/22/2010)

---

Yeah, check permissions on the account being used to start the agent. services.msc. you will find the account info in there. If it isa domain account, check...

OK, I understand that to mean the Config Manager will take care of appropriating the right permissions to the service account for the service "automatically". Otherwise, the only place...

Hmm, that is in conflict with what Editor said:

"You don't want to use Control Panel since it doesn't set the proper permissions."

Also, I am administrator and my logon password works...

Steve Jones - Editor (6/22/2010)

---

Here's what I'd do. Create a new local account. Then us the Configuration Manager to set this as the account for SQL Agent. You don't want...

Andrew, I think I finally know what you mean. I went to properties under the service and see that I am able to specify which account to operate the service...

Update,

I re-entered the password in the password field for the service account that I am running SQL Server Agent under and hit Start again.

The service is now running. ...

additionally I turned Agent XPs on because in Object Explorer Agent XPs were disabled:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Agent XPs', 1;

GO

RECONFIGURE

GO

Still in Server Configuration Manager I can't start SQL Agent.

further reading stated "This issue may occur if the sysadmin server role login of the SQL Server Agent service account or the SQL Server Agent service security principal (SID)...

henners72 (6/22/2010)

---

Yeah, check permissions on the account being used to start the agent. services.msc. you will find the account info in there. If it isa domain account, check...

Event Logs show the corresponding Event IDs to be 7000 and 7038....

In response to Old Hand:

I restarted my computer and for the love of man I am seeing a different set of states and Log Ons:

1. SSIS ...

In response to Old Hand:

I have my SQL Server installed on a computer that is part of a WorkGroup network (my home), therefore I am not using Active...

In response to Dan.Humphries:

In config manager under services I see that

1. SQL Server Agent is Not Started, Startup Type is Manual, and Log On As: .\Administrator.

2....