I'm aware of KB article 239885 about how to channge SQL accounts on a SQL
virtual server. However, is there an easier way to ensure the account has the
correct privileges (i.e. run the SQL Server installation setup again and set
the accounts there)?

Thanks in advance for your help.

I like this article
http://support.microsoft.com/default...b;en-us;269229

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"Scott Matthews" <Scott Matthews (AT) discussions (DOT) microsoft.com> wrote

Sorry, I wan't very clear. I was referring to the SQL Server and SQL Agent
Service accounts.

"Rodney R. Fournier [MVP]" wrote:

To change the account under which the SQL Server virtual server or SQL Server Agent runs, you must use SQL Server Enterprise Manager. Using this tool to change the
service password will make the change on all the nodes and grant the necessary permissions to the selected user account.

If for whatever reasons, you cannot use Enterprise Manager then review the following for the necessary permissions

SQL Server Books Online topic Setting up Windows Services Accounts
HOW TO: Change the SQL Server or SQL Server Agent Service Account Without Using SQL Enterprise Manager in SQL Server 2000
http://support.microsoft.com/?kbid=283811

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx