Re: Sync SQLServer Agent password with domain

From: Gary Chang (v-garych_at_online.microsoft.com)
Date: 07/03/04 

Date: Sat, 03 Jul 2004 09:41:53 GMT

Hi Kees

Sorry for my troublesome code, I also take some time to repair my
SQLSERVERAGENT service, it appears that the VB.NET interop will parse the
vbNullString into NULL to call the ChangeServiceConfig API, instead of
taking vbNull as NULL that I take for granted(it parse it as an empty
string on the contrary which caused the disaster :(
 

> Will this work, even if it runs during system startup? Is there a
> preferred approach that you can recommend?

I think it is possible, how about make this VB.NET as an Windows Service
which runs under the LocalSystem account to trap that event, or directly
make this service as a proxy(wrapping service) to the target service(e.g.
SQLSERVERAGENT: I mean change SQLSERVERAGENT 's execute path to this
service, and install another service whichs target to the original
SQLSERVERAGENT(..\sqlagent.exe), then put your code in the new proxy
service's OnStart sub, and close the real SQLSERVERAGENT service in the
proxy service's OnStop sub, ... it sounds well, but maybe another damn idea
:)

Thanks!

Best regards,

Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------