 | |
Unable to start agent
microsoft.public.sqlserver.server microsoft.public.sqlserver.server
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Unable to start agent -
01-25-2008
, 01:37 PM
#2
| |||
| |||
|
|
I am having an issue where I cannot start the sql agent service using a domain user account. When using SQL configuration manager to change the service account logon to a domain user account, i receive WMI Provider error, processes terminated unexpectedly error 0x8007042B It does seem to change the service logon as account to the domain user account though. Afterwards, if I try to start the service using computer management, i get: The SQL Server Agent service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service. I don't see anything in the event log. When I check the SQL Agent log, it states: 2008-01-25 16:52:12 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2008-01-25 16:52:12 - ? [098] SQLServerAgent terminated (normally) The service will run as localsystem. The service will also start if I add the domain user account to the local administrators group but I do not want to do this for security reasons. The domain user account I am trying to use has been granted: Act as part of the operating system Adjust memory quotas for a process Bypass traverse checking Log on as a batch job Log on as a service Replace a process level token I have verified this by doing an RSOP. It is the same policy and user account that is functioning normally on other SQL Servers. Any help would be appreciated. TIA, |
#3
| |||
| |||
|
|
I am having an issue where I cannot start the sql agent service using a domain user account. When using SQL configuration manager to change the service account logon to a domain user account, i receive WMI Provider error, processes terminated unexpectedly error 0x8007042B It does seem to change the service logon as account to the domain user account though. Afterwards, if I try to start the service using computer management, i get: The SQL Server Agent service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service. I don't see anything in the event log. When I check the SQL Agent log, it states: 2008-01-25 16:52:12 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2008-01-25 16:52:12 - ? [098] SQLServerAgent terminated (normally) The service will run as localsystem. The service will also start if I add the domain user account to the local administrators group but I do not want to do this for security reasons. The domain user account I am trying to use has been granted: Act as part of the operating system Adjust memory quotas for a process Bypass traverse checking Log on as a batch job Log on as a service Replace a process level token I have verified this by doing an RSOP. It is the same policy and user account that is functioning normally on other SQL Servers. Any help would be appreciated. TIA, |
#4
| |||
| |||
|
|
I am having an issue where I cannot start the sql agent service using a domain user account. When using SQL configuration manager to change the service account logon to a domain user account, i receive WMI Provider error, processes terminated unexpectedly error 0x8007042B It does seem to change the service logon as account to the domain user account though. Afterwards, if I try to start the service using computer management, i get: The SQL Server Agent service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service. I don't see anything in the event log. When I check the SQL Agent log, it states: 2008-01-25 16:52:12 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2008-01-25 16:52:12 - ? [098] SQLServerAgent terminated (normally) The service will run as localsystem. The service will also start if I add the domain user account to the local administrators group but I do not want to do this for security reasons. The domain user account I am trying to use has been granted: Act as part of the operating system Adjust memory quotas for a process Bypass traverse checking Log on as a batch job Log on as a service Replace a process level token I have verified this by doing an RSOP. It is the same policy and user account that is functioning normally on other SQL Servers. Any help would be appreciated. TIA, |
#5
| |||
| |||
|
|
I am having an issue where I cannot start the sql agent service using a domain user account. When using SQL configuration manager to change the service account logon to a domain user account, i receive WMI Provider error, processes terminated unexpectedly error 0x8007042B It does seem to change the service logon as account to the domain user account though. Afterwards, if I try to start the service using computer management, i get: The SQL Server Agent service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service. I don't see anything in the event log. When I check the SQL Agent log, it states: 2008-01-25 16:52:12 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2008-01-25 16:52:12 - ? [098] SQLServerAgent terminated (normally) The service will run as localsystem. The service will also start if I add the domain user account to the local administrators group but I do not want to do this for security reasons. The domain user account I am trying to use has been granted: Act as part of the operating system Adjust memory quotas for a process Bypass traverse checking Log on as a batch job Log on as a service Replace a process level token I have verified this by doing an RSOP. It is the same policy and user account that is functioning normally on other SQL Servers. Any help would be appreciated. TIA, |
#6
| |||
| |||
|
|
I am having an issue where I cannot start the sql agent service using a domain user account. When using SQL configuration manager to change the service account logon to a domain user account, i receive WMI Provider error, processes terminated unexpectedly error 0x8007042B It does seem to change the service logon as account to the domain user account though. Afterwards, if I try to start the service using computer management, i get: The SQL Server Agent service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service. I don't see anything in the event log. When I check the SQL Agent log, it states: 2008-01-25 16:52:12 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2008-01-25 16:52:12 - ? [098] SQLServerAgent terminated (normally) The service will run as localsystem. The service will also start if I add the domain user account to the local administrators group but I do not want to do this for security reasons. The domain user account I am trying to use has been granted: Act as part of the operating system Adjust memory quotas for a process Bypass traverse checking Log on as a batch job Log on as a service Replace a process level token I have verified this by doing an RSOP. It is the same policy and user account that is functioning normally on other SQL Servers. Any help would be appreciated. TIA, |
#7
| |||
| |||
|
|
I am having an issue where I cannot start the sql agent service using a domain user account. When using SQL configuration manager to change the service account logon to a domain user account, i receive WMI Provider error, processes terminated unexpectedly error 0x8007042B It does seem to change the service logon as account to the domain user account though. Afterwards, if I try to start the service using computer management, i get: The SQL Server Agent service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service. I don't see anything in the event log. When I check the SQL Agent log, it states: 2008-01-25 16:52:12 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2008-01-25 16:52:12 - ? [098] SQLServerAgent terminated (normally) The service will run as localsystem. The service will also start if I add the domain user account to the local administrators group but I do not want to do this for security reasons. The domain user account I am trying to use has been granted: Act as part of the operating system Adjust memory quotas for a process Bypass traverse checking Log on as a batch job Log on as a service Replace a process level token I have verified this by doing an RSOP. It is the same policy and user account that is functioning normally on other SQL Servers. Any help would be appreciated. TIA, |
#8
| |||
| |||
|
|
I am having an issue where I cannot start the sql agent service using a domain user account. When using SQL configuration manager to change the service account logon to a domain user account, i receive WMI Provider error, processes terminated unexpectedly error 0x8007042B It does seem to change the service logon as account to the domain user account though. Afterwards, if I try to start the service using computer management, i get: The SQL Server Agent service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service. I don't see anything in the event log. When I check the SQL Agent log, it states: 2008-01-25 16:52:12 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2008-01-25 16:52:12 - ? [098] SQLServerAgent terminated (normally) The service will run as localsystem. The service will also start if I add the domain user account to the local administrators group but I do not want to do this for security reasons. The domain user account I am trying to use has been granted: Act as part of the operating system Adjust memory quotas for a process Bypass traverse checking Log on as a batch job Log on as a service Replace a process level token I have verified this by doing an RSOP. It is the same policy and user account that is functioning normally on other SQL Servers. Any help would be appreciated. TIA, |
#9
| |||
| |||
|
|
Hi Jason Did you check out http://blogs.msdn.com/stuartpa/archi...12/480223.aspx John "Jason Blair" <JasonBlair (AT) discussions (DOT) microsoft.com> wrote in message news:8AC7E4FD-7E5E-42FA-93CD-76C5797645A7 (AT) microsoft (DOT) com... I am having an issue where I cannot start the sql agent service using a domain user account. When using SQL configuration manager to change the service account logon to a domain user account, i receive WMI Provider error, processes terminated unexpectedly error 0x8007042B It does seem to change the service logon as account to the domain user account though. Afterwards, if I try to start the service using computer management, i get: The SQL Server Agent service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service. I don't see anything in the event log. When I check the SQL Agent log, it states: 2008-01-25 16:52:12 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2008-01-25 16:52:12 - ? [098] SQLServerAgent terminated (normally) The service will run as localsystem. The service will also start if I add the domain user account to the local administrators group but I do not want to do this for security reasons. The domain user account I am trying to use has been granted: Act as part of the operating system Adjust memory quotas for a process Bypass traverse checking Log on as a batch job Log on as a service Replace a process level token I have verified this by doing an RSOP. It is the same policy and user account that is functioning normally on other SQL Servers. Any help would be appreciated. TIA, |
#10
| |||
| |||
|
|
Hi Jason Did you check out http://blogs.msdn.com/stuartpa/archi...12/480223.aspx John "Jason Blair" <JasonBlair (AT) discussions (DOT) microsoft.com> wrote in message news:8AC7E4FD-7E5E-42FA-93CD-76C5797645A7 (AT) microsoft (DOT) com... I am having an issue where I cannot start the sql agent service using a domain user account. When using SQL configuration manager to change the service account logon to a domain user account, i receive WMI Provider error, processes terminated unexpectedly error 0x8007042B It does seem to change the service logon as account to the domain user account though. Afterwards, if I try to start the service using computer management, i get: The SQL Server Agent service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service. I don't see anything in the event log. When I check the SQL Agent log, it states: 2008-01-25 16:52:12 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2008-01-25 16:52:12 - ? [098] SQLServerAgent terminated (normally) The service will run as localsystem. The service will also start if I add the domain user account to the local administrators group but I do not want to do this for security reasons. The domain user account I am trying to use has been granted: Act as part of the operating system Adjust memory quotas for a process Bypass traverse checking Log on as a batch job Log on as a service Replace a process level token I have verified this by doing an RSOP. It is the same policy and user account that is functioning normally on other SQL Servers. Any help would be appreciated. TIA, |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.