dbTalk Databases Forums  

SQL Server 2005 cluster reverts to Windows only mode after failove

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL Server 2005 cluster reverts to Windows only mode after failove in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ant-nee
 
Posts: n/a

Default SQL Server 2005 cluster reverts to Windows only mode after failove - 01-29-2010 , 10:45 AM






All,

SQL Server 2005 EE SP3 CU1 in an active-passive failover cluster
configuration.

Whenever I fail over the cluster or restart SQL Server, the SQL Server
reverts from mixed mode to Windows mode.

I've read that this is a known issue with SP3 CU1 and other later CUs for
SP3. Is this true?

Also, if it's true, will SP4 resolve this issue?

On a side note, can you use sp_procoption to write a startup stored
procedure that will automatically put the serverin mixed mode at startup?

Thanks for any and all help.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.