September 2, 2011 at 10:50 pm
Hi,
Now all SQL Server 2008 services are Database Engine, Agent, SSIS, SSRS, SSAS running under WINDOWS / NETWORK AUTHORITY services.
Could anyone suggestion me,
I want to change all the services windows domain id, if changed what are the impact in SQL Server 2008 side?
Could anyone suggestion me.
windows domain id, what are maximum privileges required and domain id should be add to local administrators group at server side?
Thanks in advance
September 4, 2011 at 8:39 am
Procedure to change the logon account for SQL Server service is as follows:
Start -> Run -> Services.msc -> Navigate to SQL Server Service -> Right click -> Properties
Go to tab 2 (Log On) -> Navigate to This Account text box -> Browse for the account (AD/Local account) -> Enter the corresponding password -> Click on OK
Changes will take an effect only after you restart your service.
Basically managing the service with windows AD account is a good practice. If you setup LOGSHIPPING/MIRRORING/REPLICATION with another server in same domain, then running services with domain account will ease out the setup procedure.
The account under which your SQL Server runs need not to be in LOCAL ADMINISTRATOR group.
SQLforU
info@sqlforu.com
For online training on SQL Server and Sybase, please contact
contact@sqlforu.com
www.sqlforu.com
September 4, 2011 at 9:02 am
You should change the Service Account in SQL Server Configuration Manager.
Instructions:
http://msdn.microsoft.com/en-us/library/ms345578.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply