Re: Can MSDE run SQL Server Agent service in Win98

From: Greg Low \(MVP\) (greglow_at_lowell.com.au)
Date: 02/17/04 

Date: Tue, 17 Feb 2004 15:44:04 +1000

Hi Andrea,

I have some recollection of a problem involving the agent and win98 where a
non-blank sa password was set with mixed mode. Can't for the life of me find
the reference though. Do you recall it?

Regards, 

-- 
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:c0qmi4$1an3er$1@ID-207518.news.uni-berlin.de...
> 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: 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)
  • Re: Error running DTS package on a schedule (only!)
    ... Right Click on the SQL Server Agent icon in EM and choose properties. ... > How do I determine which account was used to start SQL Agent? ... >> | When I try to schedule a job for this DTS package under SQL Server ...
    (microsoft.public.sqlserver.dts)