Hi folks,
I have a SQL 2005 OTC. CTP version running on Windows 2003 server.
I would like to find out how the SQL server option changed to Windows Authentication mode from Mixed mode over the weekend. From the SQL log, I don't see when it changed. I would like to see Date/Time and client IP. If I can see User ID (windows) that would be great. Where I can find these info in SQL server?
Thank you in advance...
SHJ
If you were not explicitly auditing server logins during that period, you cannot obtain this information later. Also, an authentication mode change will not take effect until the server is restarted. Was your server restarted over the week-end? You should be able to see this from the errorlogs because a new errorlog would be started.
Thanks
Laurentiu
No comments:
Post a Comment