April 9, 2010 at 4:34 am
Hi,
I'm connected to SQL Server through SQL Server authentication. I'm using a login named test1 to connect to the database.
If i alter the pwd of this login while i'm logged on, i can still do all the operations with him, even after i have changed the password, correct?
I can alter a pwd of a login while i'm connected with it and only when i disconnect and reconnect again i need to suplly the new password, am i correct?
Thank you
April 9, 2010 at 4:46 am
as far as i am aware this is correct for sql logins only
however it would be wise to check this before you accept my response as accurate
I can conformt that the behaviour of windows authentication behaves slightly differently - especially in cases wher the users password expires... in these instances the client continues to pass the old password to sql, which checked with the domain and find the password is no longer accurate.
MVDBA
April 9, 2010 at 8:15 am
That's absolutely correct. SQL works in a similar way to Windows - once you are authenticated in the server you're fine until you disconnect. This is the same with Integrated logins in that you can log in to SQL using Integrated Security, say in SSMS, then change your Windows password outside of SSMS (there's no option to do it from inside). You can continue to work until you disconnect; of course, when you reconnect, SQL asks Windows if the user is authenticated and finds it is so it works seamlessly - with a SQL login you do need to put in the new password next time you connect...!
April 9, 2010 at 8:25 am
Thanks for the help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply