I want to enabled mixed-mode authentication on sqlserver 2000 box on a cluster. After enabling the mixed-mode on the sqlserver properties. Will a failover and failback will enable the mixed-mode immediately.
If you enable mixed mode authentication, the settings will remain even when the server fails over and back.
answered Mar 10 '10 at 12:32 AM