Re: Autostart MS Agent on Win98/Me

From: Gert E.R. Drapers (GertD_at_SQLDev.Net)
Date: 01/10/05

  • Next message: Manzoorul Hassan: "Renaming a system (host) after MSDE is installed" 
    Date: Mon, 10 Jan 2005 20:14:32 +0100

    That will never work on Windows 9x based OS's since there is no concept of a
    real service which gets started with NET START. Only Windows NT based OS's
    (and OS/2) have NET START.

    You can use SCM.EXE instead

    GertD@SQLDev.Net

    Please reply only to the newsgroups.
    This posting is provided "AS IS" with no warranties, and confers no rights.
    You assume all risk for your use.
    Copyright © SQLDev.Net 1991-2004 All rights reserved.

    "Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> wrote
    in message news:eU1Ed3y9EHA.2876@TK2MSFTNGP12.phx.gbl...
    > If you really rely on SQL Server Agent being started and you have not a
    > lot of control over the machine, start SQL Server Agent from within SQL
    > Server:
    >
    > -- Create a procedure to start SQL Server Agent
    > USE master
    > GO
    > CREATE PROC usp_start_sqlserveragent
    > AS
    > EXEC master..xp_cmdshell 'net start SQLServerAgent'
    > GO
    > -- Mark stored procedure to run on SQL Server start
    > EXEC sp_procoption 'usp_start_sqlserveragent', 'startup', 'true'
    >
    > --
    > Jacco Schalkwijk
    > SQL Server MVP
    >
    >
    > "Allcomp" <marc@nospam.allcomp.be> wrote in message
    > news:41e279f2$0$2676$ba620e4c@news.skynet.be...
    >> Hello,
    >>
    >> does anyone know how I could autostart the MSAgent on Win98/Me with a
    >> named instance.
    >>
    >> I try with
    >> scm.exe -Action 1 -Service SQLAgent$$" & str_InstanceName
    >>
    >> where str_InstanceName is the name of the MSDE Instance.
    >> The password is correct (I exported the crypted password from a computer
    >> with Entreprise manager and the agent start with WinNT...
    >> It can also start manually.
    >> On Winnt, 2K and XP, all is fine, on Win98/Me, I receive the message
    >> Service operation has been completed successfully but the agent did not
    >> start. I can manually start the agent with the MSDE service manager, but
    >> if my custommer forget it then he has no automatic backup of his
    >> database.
    >>
    >>
    >>
    >> Thank you
    >> Marc Allard
    >> Allcomp
    >
    >

  • Next message: Manzoorul Hassan: "Renaming a system (host) after MSDE is installed"

    Relevant Pages

    • Re: Autostart MS Agent on Win98/Me
      ... If you really rely on SQL Server Agent being started and you have not a lot ... > with Entreprise manager and the agent start with WinNT... ... I can manually start the agent with the MSDE service manager, ...
      (microsoft.public.sqlserver.msde)
    • Re: Problems with SQL Srv. Agent and Proxy Account
      ... You need to go to the General Tab of the SQL Server Agent ... >I have tried with both the sa account and with Use Windows ...
      (microsoft.public.sqlserver.security)
    • RE: Run SQL Server services with the lowest possible privileges.
      ... SQL Server 2000 and SQL Server Agent run as Windows services. ... made with the security context of the Windows account that owns the server ...
      (microsoft.public.sqlserver.security)
    • Re: File system defragmenting?
      ... SQL Server Agent service is dependent to SQL ... Services on the server before performing the Windows disk defrag. ...
      (microsoft.public.sqlserver.setup)
    • Problem with SQL Server Agent.
      ... SQL Server 2000 sp3 on Windows 2003. ... following error in the sql server agent log and I am not ...
      (microsoft.public.sqlserver.server)
    Loading