|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > SQL Server 2000 - SQLServerAgent won't start
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2000 - SQLServerAgent won't start
|
|
|
| We are using SS2000 w/sp1 on a cluster setup. During a failover the
SQL Server Agent resource failed to come back online. The only error
messages I could find came from Event Viewer:
Application popup: sqlagent.exe - Application Error : The application
failed to initialize properly (0xc0000142). Click on OK to terminate
the application
There were no error messages in the SQLAgent.out file.
The only way we could get SQLServerAgent to come back online was to
change the Startup service account from a domain to a local account.
MSSQLServer still uses the domain account and works fine, but the
SQLServerAgent service will not.
| |
| [MS] Eric Yang 2002-08-13, 9:23 pm |
| Hello,
Since the local administrator can work, we need check the privilege of the
domain account.
Please try the following steps to find the root cause.
1.Checked for permissions on the SQLServerAgent key for the service account
(domain account) for these registry keys:
HKEY_LOCAL_MACHINE -> SOFTWARE -> MICROSOFT -> MSSQLSERVER ->
SQLSERVERAGENT
"Security" Menu -> Permissions Make sure the account had full control
permissions.
HKEY_LOCAL_MACHINE -> SYSTEM -> CURRENTCONTROLSET -> SERVICES ->
SQLSERVERAGENT
"Security" Menu -> Permissions) Make sure the account had full
control permissions.
2. We also need check to see if the domain account had the required user
rights and it did plus it was part of the local administrator's group
3. Removed the domain account under which they were starting SQL Agent from
the local administrators group and then added it back. Made sure the
MSSQLServer service account is also part of the local administrator's
group.
4. Right clicked SQL Server Agent in Enterprise Manager and chose
properties.
In the General tab, made sure the file name for Errorlog, showed a valid
file path (ex: c:\program files\Microsoft SQL
Server\mssql\log\sqlagent.out), including the name of the errorlog file.
5. Checked to make sure the MSSQLSERVER service startup domain account had
full control permission to the following keys.
HKEY_LOCAL_MACHINE\SYSTEM\CURR
ENTCONTROLSET\SERVICES\MSSQLSE
RVER
HKEY_LOCAL_MACHINE\SYSTEM\CURR
ENTCONTROLSET\SERVICES\SQLSERV
ERAGENT
HKEY_LOCAL_MACHINE\SYSTEM\CURR
ENTCONTROLSET\SERVICES\MSDTC
6. Opened up registry and removed the startup account for MSSQLServer and
SQLServerAgent from Security -> Permissions box for the following keys and
add them back and made sure the "Allow inheritable permissions from parent
to propagate to this object" was checked:
HKEY_LOCAL_MACHINE\SYSTEM\CCS\
SERVICES\MSSQLSERVER
HKEY_LOCAL_MACHINE\SYSTEM\CCS\
SERVICES\SQLSERVERAGENT
HKEY_LOCAL_MACHINE\SYSTEM\CCS\
SERVICES\MSDTC
7. Restart both MSSQLServer and SQLServerAgent services. Please see whether
it can work with domain account.
In addition, the problem may be caused if there is no enough memory to
create the desktop heap for the non-interactive service that was being
started.
Checked this registry key:
HKEY_LOCAL_MACHINE\System\Curr
entControlSet\Control\SessionM
anager\SubSystem
s\
Windows section: ObjectDirectory=\Windows SharedSection
For a Windows 2000 Server, there will be four parameters: 1024, 3072, 512,
512. Can you find it in your machine? If not, please change to the four
parameters and reboot the machine.
Sincerely,
Eric Yang [MS]
Microsoft Online Support Engineer
Please do not send email directly to this alias. This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security
| |
| Manuel Gamez 2002-08-15, 7:23 am |
| Changing the "Desktop Heap" registry entry corrected the problem thanks
for your help.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
|
|
|
|
|