| How to change SQL Server service account |
|
|
|
|
Follow the below guide lines when changing/selecting an SQL Server or SQL Server agent service account. Make sure to change the service account from Enterprise Manager(SQL 2000) or Configuration manager Also note that , its always better to have 2 domain service accounts , 1 domain account for sql server with local system privilege
1) Open Enterprise Manager 3) Go to Security tab, in the Startup service account, give the new service account & click ok
Also for changing the service account for SQL Agent,
1) Management -> SQL Server Agent, right click Properties
2) Modify the Service starup account & click ok
For SQL Server 2005, follow the below guide lines
2) Select SQL Server 2005 Services in the pane on the left. 3) In the pane on the right, select the service whose account you want to alter, right-click,
4) Change the account & click apply
Comments (59)
Powered by !JoomlaComment 4.0 beta2
|


