0

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

1

2 Answers 2

1

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???

8
  • @arenstar how do we correct it if it's daylight savings? Nov 8, 2010 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, 2010 at 19:47
  • support.microsoft.com/kb/914387#appliesto You havent done your Updates im guessing :D
    – Arenstar
    Nov 8, 2010 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 Nov 8, 2010 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, 2010 at 19:52
1

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?

4
  • @arenstar how do we correct it if it's daylight savings? Nov 8, 2010 at 19:48
  • how would i know that it is daylight problem Nov 8, 2010 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. Nov 8, 2010 at 20:21
  • and then what? the time is the same as everyone else's Nov 8, 2010 at 20:23

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .