question

Chandoo5599 avatar image
Chandoo5599 asked

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

sql-server-2000administrationclusterauthentication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

If you enable mixed mode authentication, the settings will remain even when the server fails over and back.

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ ·
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?"
0 Likes 0 ·
CirqueDeSQLeil avatar image CirqueDeSQLeil ·
With that in mind, then a failover will cause the change to take effect.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.