Follow-up for Gail:

Is there a command-line directive to SQL Enterprise Mgr that can change the Log In Properties of the Server?

My hunt so far has not been successful.

I would prefer...

Thanks for the tip.

We run SQL Server 2000. I was pointed to the instance Security Page under SQL Server Enterprise Manager, where I could set the Log in Acct/Password....

Michael:

Thanks for your input:

Just a few questions - out of curiosity:

1. why do you need to do this with a script? do you intend to turn it on and off...

Thanks very much for your help!

Does this require a reboot?