Re: Can MSDE run SQL Server Agent service in Win98

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 02/16/04 

Date: Mon, 16 Feb 2004 16:10:55 +0100

hi Zero,
"Zero" <anonymous@discussions.microsoft.com> ha scritto nel messaggio
news:10fcb01c3f450$74acd270$a601280a@phx.gbl...
> Hi,
>
> I installed MSDE in WIN 98. Afterthat, I cannot run its
> SQL Server Agent service. Thus, I cannot run the
> backup/restore utilities. Is it true? How to solve?
>
> Thanks.

AFAIK the SQL Server Agent runs on Win9x with no problem..... it can not be
run as a service becouse Win9x does not support it, but you can start it as
a standard application (the same is true for SQL Server).. the only problem
is to run it at startup... you have to takle a little with some hacks... 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.6.0  -  DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Relevant Pages

  • Re: How to restrict access to database to only IUSR_<machinename>
    ... > If SQL Server service didn't start, SQL Server Agent service will not be ... Open a command line window. ...
    (microsoft.public.sqlserver.security)
  • Problems connecting to SQL Server after installation
    ... I set it to start SQL Server and the Agent using the local System Account ... But every time I try to restart the Agent - I get: ... Do I really need the SQL Server Agent Service started? ...
    (microsoft.public.sqlserver.setup)
  • 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: Can MSDE run SQL Server Agent service in Win98
    ... >> SQL Server Agent service. ... > AFAIK the SQL Server Agent runs on Win9x with no problem..... ... > run as a service becouse Win9x does not support it, ...
    (microsoft.public.sqlserver.msde)
  • RE: DTS Package fails when Scheduled
    ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
    (microsoft.public.sqlserver.dts)