Re: Account for SQL Server services



Use Enterprise Manager to change the SQL Server or SQL Agent service account
information. EM is cluster-aware and will make all necessary changes for
you.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Chen" <Chen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51ED33DF-3880-46AB-879C-E00DE0E0670F@xxxxxxxxxxxxxxxx
> Hi,
>
> When I install cluster SQL Server in two nodes (active-passive), I used
> valid administrator account for all nodes. After install, I changed SQL
> Agent
> service account for replicate database. SA asked me to change the SQL
> Server
> service account to not using currently administrator account under the
> domain. If I changed what happy after stop and restart SQL, the cluster
> will
> work or not? I mean the failover or fail back.
>
> Regards!
> -Chen


.



Relevant Pages

  • 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)
  • Re: A complicate cluster configuration...
    ... The SQL Server 2000 EE will be running just in one node, ... It is possible that an operator can manage the cluster from a terminal ... > and SFTPs them to a remote machine. ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... the first instance on the cluster. ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)