How to change SQL Agent/Server start up account?
Hi, I have an existing 2 node active-actvie SQL 2008 R2 Veritas 6.0 cluster. When I installed the SQL instance on each node, I set a specific AD user for starting the SQL Agent and SQL Server service. I set it the same on each node. I now want to change that to a different user. I know how to do that via the SQL Server Configuration Manager on each node, but is that the correct way to do it in a Veritas cluster? Changing it there will restart the service and cause a failover I believe. What is the correct way to do this?