March 5, 2009 at 2:12 pm
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
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?
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]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply