Re: Can MSDE run SQL Server Agent service in Win98

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

Date: Tue, 17 Feb 2004 18:23:50 +0100

hi Greg,
"Greg Low (MVP)" <greglow@lowell.com.au> ha scritto nel messaggio
news:OsbdPkR9DHA.2064@TK2MSFTNGP11.phx.gbl...
> 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?

nope.... remember something as well (now that you said it) but can't be more
precise...
but think that
EXEC master.dbo.xp_sqlagent_proxy_account N'SET',
             N'LocalComputerName', -- agent_domain_name\localcomputername
             N'TheAgentUserName', -- agent_username
             N'TheAgentPassword', -- agent password

coul'd fix that i the service is running and if regarding account login
troubles, but if the server does'nt start at all... =:-((
other hints?? 

-- 
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: Text of Startup Option Application Title
    ... This is a quote from Mary Chipman, SQL Server MVP, ex-Access MVP, and author ... DAO was designed, customized, and tweaked specifically for the Jet ... ADO was designed as a general-purpose data access wrapper around OLE ...
    (microsoft.public.access.formscoding)
  • Re: Reading Layout View...Again: The Solution
    ... Thanks for posting back. ... Many MVPs are adamant about the side effects of using these "registry cleaners", ... Andrea wrote: ... Microsoft Office MVP ...
    (microsoft.public.office.misc)
  • Re: Autonumbers vs Identity Key
    ... "Pat Hartman (MVP)" wrote: ... The reason that SQL Server doesn't assign an autonumber immediately is ... > I then had to make bF9 true before doing the recalc, ... >> Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.conversion)
  • Re: Active/Active clustering
    ... > The OS and the SQL Server executables gets installed on the local drive. ... > Mike Epprecht, Microsoft SQL Server MVP ... So, I need an SAN attached storage device, so ...
    (microsoft.public.sqlserver.clustering)
  • Re: ? re. Legal Apps? & ODBC?
    ... based connections (SQL Server & Sybase SQL Anywhere) ... Universal Data Access & Virtual Database Technology Providers ... > All responses should be made to this newsgroup within the same thread. ... >> MVP Entourage ...
    (microsoft.public.mac.office.entourage)