Enabling MixedMode authentication

Hi,

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.

Thanks,
Chandra

asked Mar 10 '10 at 12:09 AM in Default

Chandoo5599
118 ● 5 ● 6 ● 7

(comments are locked)

1 answer:

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

CirqueDeSQLeil
3.9k ● 8 ● 11 ● 15

The question seems to be getting at when the change would take effect rather than whether it would remain in effect. Maybe along the lines of... "Does the mixed mode change take effect immediately? If not, will a failover/back make the change take effect?"

Mar 10 '10 at 01:06 AM KenJ

With that in mind, then a failover will cause the change to take effect.

Mar 10 '10 at 01:16 AM CirqueDeSQLeil

(comments are locked)