MSSqlServer service and Windows password reset

Hello,
I hope you guys can help me with a problem that I am facing...

I have started the MSSqlServer service and SQLServerAgent services
with a domain username and password.
There are periodic password resets to this user. Security policies
within the company dictate that the password for this domain account
cannot be permenant.

Would there be any way to automatically reset the pwd in these
services instead of manually changing them each time?

ThanksKannan (pv_kannan@.yahoo.com) writes:
> Would there be any way to automatically reset the pwd in these
> services instead of manually changing them each time?

I doubt there is, but since this is not really a MS SQL Server issue,
but rather a generic Windows question, a question to the approriate
newsgroup for Windows.

Personally, I would investigate possibilities to set up the account
so that it only can log in as service or some such, which would permit
unexpirable passwords.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

MSSqlServer service and Windows password reset

Hello,
I hope you guys can help me with a problem that I am facing...
I have started the MSSqlServer service and SQLServerAgent services
with a domain username and password.
There are periodic password resets to this user. Security policies
within the company dictate that the password for this domain account
cannot be permenant.
Would there be any way to automatically reset the pwd in these
services instead of manually changing them each time?
ThanksKannan,
Is there a specific reason why these can't run under
system?
If not, try to shift the responsibility back to the group
with the security requirement. It would be reasonable to
ask that the admin user who changes the password should
also update the password in the services at the same time
(to ensure continuous availability). If this becomes too
onerous for them, perhaps they'll rethink their
application of the policy in this case.
BTW, I don't think services need to be stopped in order to
change the account password (i.e., wouldn't affect
availability). Can anyone else confirm?
...Jeff
>--Original Message--
>Hello,
>I hope you guys can help me with a problem that I am
facing...
>I have started the MSSqlServer service and SQLServerAgent
services
>with a domain username and password.
>There are periodic password resets to this user. Security
policies
>within the company dictate that the password for this
domain account
>cannot be permenant.
>Would there be any way to automatically reset the pwd in
these
>services instead of manually changing them each time?
>Thanks
>.
>