SQL Server Authentication password resets during reboot

Hi!

I have a problem with SQL Server Authentication password getting reset when the server reboots.

In SQL Server Enterprise Manager I go to Security > Logins > Choose Properties for the user I want to change password on. Then I change the Server Authentication password and get a window to confirm the password.

The password changes sucessfully and the application that needs the password is working fine. But when the server reboots this password get changed and I have to change it again for the application to work.

Anyone have any ideas why the password isn't systained during reboot?

[628 byte] By [Bombastic] at [2007-12-23]

SQL Server

Site Classified