March 15, 2005 at 11:07 am
We are planning on changing the startup account for our SQL 2000 Production Servers. The Servers are clustered and are currently configured to run under the domain administrator account.
We plan to change it to run under a domain user account with local administrator priveleges. We are also using SQLMail and Replication. We would like to configure SQLServer,SQLAgent and SQLMail to all use the same account.
Will this cause problems as the servers are in a clustered environment and would the account require any additional priveleges ? Will this change affect any 3rd party applications connecting to SQL ? Is there any standard test procedures to ensure proper functionality of the servers and related apps ?
Thanks
March 15, 2005 at 1:55 pm
You will have no problems that I can forsee, as long as the Domain User account is a local Admin. I would recommend trying this on a test / development server first.
A.J.
DBA with an attitude
March 15, 2005 at 11:19 pm
We have clustered enviroment running on one domain account, which has local admin rights on both cluster nodes. On the same domain account run SQL server agent and SQL mail. No problems with that till now and I hope there wouldn't be them in the future
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply