According to the minimum required security configuration of MS SQL SERVER,

MS SQL SERVER user must be forced password expiration,

Password expiration or 90 days later, using the new password,

Ask: the user name and password are written into the program, such a case, besides must update every time, still have what good method, can make the program in a timely manner on the talents database?

CodePudding user response:

You all write in the program died, that in addition to the upgrade, there is no other way,
Into a variable, enter the password after each start, after changing password to enter the password,
Into a configuration file, add a secret don't configuration data is proclaimed in writing is ok, this is no way to upgrade,