I was wondering if someone would be so kind as to tell me if i'm
missing something or just plain dumb:
I am running a 2000 Advanced Server and SQL 2000 Enterprise SP3. I
changed the SQL SERVER SERVICE account to use a Local NT User account
with no enhanced privileges standard user and another account with the
same level of permissions for the SQL SERVER AGENT.
Both services start fine and I configured the SQL server to start using
the service account thru enterprise manager. As well as the
configuration for SQL SERVER AGENT was also done in Enterprise Manager.
The file system and Program files directories are configured with the
default ACL's. There is no GPO dictating who has the "log on as service
right" and both accounts (SERVER & AGENT) have the sysadmin role in
SQL.
HOWEVER: whenever I try to run a job thru SQL SERVER AGENT it does not
run and i get a message stating that the service is not running. This
message dissapears as soon as i make the accounts members of the local
administrators group.
Would there be any way to run these 2 services under the local USER
permissions and have the jobs execute sucessfully?
ANY HELP would be appreciated. I have been doing research for more than
5 days now and can't seem to find an answer.
THANks!
Miguel A. Escalante, MCSEIs the error actually:
Error 22022: SQLServerAgent is not currently running so it
cannot be notified of this action.
Some things to check - Are you running SQL Server in fiber
mode (lightweight pooling)? Have you ensured that SQL Agent
is truly running and not hung up in a starting status? Have
you checked your sqlagent.out file?
In addition to lightweight pooling being enabled, Agent can
also get hung up due to a bad mail profile.
-Sue
On 2 Nov 2005 20:13:15 -0800, miguel.a.escalante@.gmail.com
wrote:
>I was wondering if someone would be so kind as to tell me if i'm
>missing something or just plain dumb:
>I am running a 2000 Advanced Server and SQL 2000 Enterprise SP3. I
>changed the SQL SERVER SERVICE account to use a Local NT User account
>with no enhanced privileges standard user and another account with the
>same level of permissions for the SQL SERVER AGENT.
>Both services start fine and I configured the SQL server to start using
>the service account thru enterprise manager. As well as the
>configuration for SQL SERVER AGENT was also done in Enterprise Manager.
>
>The file system and Program files directories are configured with the
>default ACL's. There is no GPO dictating who has the "log on as service
>right" and both accounts (SERVER & AGENT) have the sysadmin role in
>SQL.
>HOWEVER: whenever I try to run a job thru SQL SERVER AGENT it does not
>run and i get a message stating that the service is not running. This
>message dissapears as soon as i make the accounts members of the local
>administrators group.
>Would there be any way to run these 2 services under the local USER
>permissions and have the jobs execute sucessfully?
>ANY HELP would be appreciated. I have been doing research for more than
>5 days now and can't seem to find an answer.
>THANks!
>Miguel A. Escalante, MCSEsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment