June 4, 2009 at 10:15 am
We run a report on the first of the month to list the status of SQL Server logins on all of our servers. Part of the code for this report uses the LOGINPROPERTY function to show the date the login passwords were last changed and, from this date, to calculate when the password is due to expire. We recently changed the sa password on all servers a week before the report was run. Some of the servers, however, do not show the password last change date for sa as having been changed.
Does anyone know how I would begin to investigate this problem?
Where is this date stored?
Is there any reason that this date would not be updated when the password is changed?
October 1, 2009 at 10:47 am
I am replying to this post to bump it to the top of the forum. This report is used by an auditing team so we really need an answer to this problem ASAP.
November 5, 2009 at 12:51 pm
I guess I will just have to keep bumping this until I get an answer. We really need to know how to fix this problem.
November 6, 2009 at 9:09 am
As you're having no luck in receiving a response to this query, why not post a bug report on MS' Connect site:
Chris
November 6, 2009 at 9:14 am
I already have an issue open with Microsoft, but I am not recieving any answers from them, either.
November 6, 2009 at 9:37 am
MS Connect is a place to go if you find a bug which isn't too important for you at the moment or when you have a workaround.
If you have a problem which needs to be fixed ASAP, open a Microsoft support call. Usually it takes about two or three weeks (here in GOG) until you speak with the right person (it's the third or fourth 😛 ), but this person usually can help.
Good luck
Flo
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply