Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

i have a timeclock database setup on a windows 2008 server, sql server. it has been working for MONTHS. today all of a sudden it seems like some peoples' logins is working and some peoples' login is not working. sql authentication works fine however the windows authentication is not working. i checked the log files and it seems like sql server 2008 is just not liking the passwords! does anyone know what could be going on here?

i checked the windows server error log. here is what it looks like: alt text

share|improve this question

2 Answers 2

up vote 1 down vote accepted

Well just a wild guess..

But your time is out.. So your Kerberos timestamps are out of sync, effectively shutting down your domain???? Did you just have a DayLight-Savings???

share|improve this answer
    
@arenstar how do we correct it if it's daylight savings? –  Yuck Nov 8 '10 at 19:45
    
Im a unix guy, but familiar with Kerberos.. Basically.. Set your clock to UTC and enable the daylight savings I probably would run NTP on your servers too.. To keep them in sync outside of the actual host clock.. –  Arenstar Nov 8 '10 at 19:47
    
support.microsoft.com/kb/914387#appliesto You havent done your Updates im guessing :D –  Arenstar Nov 8 '10 at 19:50
    
@arenstar i dont know if this is the right answer since even after the time change it worked but stopped working like after 12 hours or something like that –  Yuck Nov 8 '10 at 19:51
    
Im feeling pretty confident that im right.. :D But let me know if im wrong.. i would like to know –  Arenstar Nov 8 '10 at 19:52

Check the windows security event log on the domain controllers. It could be consistency between the domain controllers. Did some of the servers time sync fall out of place due to daylight savings yesterday?

share|improve this answer
    
@arenstar how do we correct it if it's daylight savings? –  Yuck Nov 8 '10 at 19:48
    
how would i know that it is daylight problem –  Yuck Nov 8 '10 at 19:54
1  
the easiest method would be from your control panel under calendar/time. or by double clicking the time on your system tray. –  Nick O'Neil Nov 8 '10 at 20:21
    
and then what? the time is the same as everyone else's –  Yuck Nov 8 '10 at 20:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.