After MSDE SP4 installation SQL Agent is set to manual

I have over 500 PC's with a named instance of MSDE installed that I need to
install SP4 on. These PC's have the SQL Agent set to automatic. After
installing SP4 on a test box, this service was changed to manual by the
service pack. replication will not work if this service is not running.
Is there a way to have the service pack set this service to be set to
automatic? Is there a way to set it to automatic with a batch program or VB
script?
I can not manually change this service on over 500 PC's.
hi,
andersos wrote:
> I have over 500 PC's with a named instance of MSDE installed that I
> need to install SP4 on. These PC's have the SQL Agent set to
> automatic. After installing SP4 on a test box, this service was
> changed to manual by the service pack. replication will not work if
> this service is not running.
> Is there a way to have the service pack set this service to be set to
> automatic? Is there a way to set it to automatic with a batch
> program or VB script?
> I can not manually change this service on over 500 PC's.
I do think via WMI, but never tried it... perhaps you have to ask in some
dev's newsgroup
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Check out this article.
http://groups-beta.google.com/group/...e67c802edd178a
There is a registry key for this service. If you change the 'start'
property of this key, you can change the service from manual to automatic.
There are a number of ways to do this through code. These are the values for
this property.
Boot = 0,
System = 1,
Automatic = 2,
Manual = 3,
Disabled = 4
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\SQLAgent
|||It is cool that you even got msde upgraded on 500 users. I can't get one
installed to upgrade my default instance sp3a to sp4. You are a hero.
In BOL look up - scm Utility
If you can find the -StartupOptions for autostart, it looks like you can do
it with a bat file or xp_cmdshell.
We replicate a table with a trigger to dynamically execute sql on insert to
propagate fixes and procs.
My test install of sp4 ran well, then the status bar backed up and it
finished like all is well but .760 still shows in the version. Did you have
anything similar ? Care to share your command line secret? I have 150 users
to push to.
andersos wrote:
>Check out this article.
>http://groups-beta.google.com/group/...e67c802edd178a
>There is a registry key for this service. If you change the 'start'
>property of this key, you can change the service from manual to automatic.
>There are a number of ways to do this through code. These are the values for
>this property.
> Boot = 0,
> System = 1,
> Automatic = 2,
> Manual = 3,
> Disabled = 4
>HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servi ces\SQLAgent
|||C:\Program Files\Microsoft SQL Server\80\Tools\Binn>scm -Action 7 -Service
sqlserveragent -SvcStartT
ype 2
This does the job. Note this path may differ
andersos wrote:
>I have over 500 PC's with a named instance of MSDE installed that I need to
>install SP4 on. These PC's have the SQL Agent set to automatic. After
>installing SP4 on a test box, this service was changed to manual by the
>service pack. replication will not work if this service is not running.
>Is there a way to have the service pack set this service to be set to
>automatic? Is there a way to set it to automatic with a batch program or VB
>script?
>I can not manually change this service on over 500 PC's.
Mike Street
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200507/1