I found today that the account the application uses to connect to the database was locked. When I looked up the account I believe it had the word TIMED on it relating to the expiration settings?
I am new to working on this so and lost my screen shot to show what it is I had found.
I unlocked the account but believe it should be set to non expiring.
We have four servers we are preparing to put into production replacing our old servers. All servers should be configured the same and only one had the account locked, which happens to be the new production server. The lower environments did not have an issue though that may be because they have been in use as we are doing our testing prior to switching to the new system.
What steps do I need to take to determine what the expiration setting is for the accounts so that I can compare between servers to see if non-expiring is what the other servers are set to for this ID?
I have been reading up but it seems every piece leads to another puzzle piece to research which leads to another, etc. If I were more familiar with how the system works it would not be so bad but everything refers to something else I have to look up until it becomes information overload while trying to make one quick fix.
We rarely have anything to do with the database directly except for setting it up initially.
At my age I still learn something new every day, but I forget two others.