Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    3

    Question Unanswered: 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?


    -Loyal

  2. #2
    Join Date
    Sep 2002
    Posts
    53

    Re: Agent AutoStart in Win98SE

    Originally 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/techinf...0/MSDE2000.asp

    HTH!
    KDK

  3. #3
    Join Date
    Nov 2002
    Posts
    3

    Re: Agent AutoStart in Win98SE

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •