I just ran into this error on a SQL 2005 cluster. It was mysterious, but
it turned out that the password the service was running on had been
changed, but the cluster hadn't been restarted/service hadn't been
re-synched with the correct password. Everything else worked, but the sa
properties would give this error if you tried to view them. Fix, for me,
was syncing the password.
Re: Issues creating a new failover cluster on the same server ... G:\Microsoft SQL Server\MSSQL.1 ...CHNSQL04 Cluster Group...Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running... (microsoft.public.sqlserver.clustering)
Re: Clustering Newbie - SAN Advice ...Senior SQL Infrastructure Consultant...SAN/Smart array or through a fibre channel switch. ... The SAN or Smart array will dictate what internal connection the disks...single-instance cluster.... (microsoft.public.sqlserver.clustering)
Re: Clustering Question ... You could make a test environnement through Virtual Machine to get a picture on Cluster. ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... > you cannot install Cluster on a Small Business Edition, ... (microsoft.public.windows.server.clustering)
Re: SQL server 2005 SP2 failing on cluster ... We have been told for a long time that MSDTC is optional on a cluster but is all but required in the real world. ... I'm having problem to update my SQL cluster with SQL server 2005 SP2. ... Package Platform: x86... see Help and Support Center at ... (microsoft.public.sqlserver.clustering)
Re: Create SQL cluster on 2003 ... Since you are in a cluster configuration,...Microsoft SQL Server MVP... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server... (microsoft.public.sqlserver.clustering)