Post reply

Authentication mode keeps changing

  • March 5, 2009 at 2:12 pm

    #206656

    I have a cluster with several SQL 2005 instances installed. On mulitple occasions I've found several (but not all) of the instances have changed authentication mode from Mixed to Windows only. I can find nothing in the logs and none of the DBAs who have access admit to changing it.

    Has anyone else experienced this? Is there a way to audit this setting?

    Thanks

    JC III

  • March 5, 2009 at 3:34 pm

    #954495

    I found it did that for me when I patched the SQL Server 2005 RTM to SP2. It went from Mixed Authentication to WIndows only authentication. Did you do any patching recently?

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply