Enabling MixedMode authentication


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.


more ▼

asked Mar 10, 2010 at 12:09 AM in Default

Chandoo5599 gravatar image

118 6 7 7

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Mar 10, 2010 at 12:32 AM

CirqueDeSQLeil gravatar image

4.8k 10 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, 2010 at 01:06 AM KenJ
With that in mind, then a failover will cause the change to take effect.
Mar 10, 2010 at 01:16 AM CirqueDeSQLeil
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 10, 2010 at 12:09 AM

Seen: 1351 times

Last Updated: Mar 10, 2010 at 12:42 AM