Agent AutoStart in Win98SE

With MSDE 2000 installs, I have tried a couple of things to get the Agent to autostart when the machine is booted. So far, I've been unsuccessful. Does anyone have experience with a working solution?

I have tried:

1. sp_set_sqlagent_properties @.auto_start = 1
2. Placing the following in the Registry: "scm.exe -Action 1 -Service SQLServerAgent -SvcStartType 2 -Silent 1" under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Run

The checkbox in the SQL Server Service manager to "Auto-start service when OS starts" is greyed out for the Agent service. Does this mean that it just cannot be done?

-LoyalOriginally posted by loyalp
With MSDE 2000 installs, I have tried a couple of things to get the Agent to autostart when the machine is booted. So far, I've been unsuccessful. Does anyone have experience with a working solution?

I have tried:

1. sp_set_sqlagent_properties @.auto_start = 1
2. Placing the following in the Registry: "scm.exe -Action 1 -Service SQLServerAgent -SvcStartType 2 -Silent 1" under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Run

The checkbox in the SQL Server Service manager to "Auto-start service when OS starts" is greyed out for the Agent service. Does this mean that it just cannot be done?

-Loyal

Here is what Microsoft has to say about it.

Windows 98 Limitations
Windows 98 does not provide support for the following features:

Windows NT authentication
Fiber mode scheduling
Asynchronous I/O
Read ahead
Performance Monitor counters
Scatter/Gather I/O
Named pipes server network library
Appletalk server or client network library
Banyan Vines server network library

Read more: http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp

HTH!|||Thanks Krusty.

Just this morning I tried adding an EXEC statement to Win98 machines at startup. This statement uses xp_servicecontrol to START the SQLServerAgent and appears to have successfully worked around the problem.

[QUOTE][SIZE=1]Originally posted by KrustyDeKlown
Here is what Microsoft has to say about it.