Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
farrokhp
Starting Member
15 Posts |
 Posted - 2011-02-28 : 05:44:13
|
| How can I change servivce account for sql engine and sql agent? I created them as default now we want to assign a network service account instead? Is the changing procedure exactly same in 2005 and 2008? Reboot needed? |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2011-02-28 : 07:55:09
|
| If you open the SQL Server Configuration Manager, and under services select the service and on the properties page you can change the service account.It will need a restart afterwards though. |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-02-28 : 16:11:03
|
| And, you need to remove the SPN record that was created under the local account. If not, you will get SSPI errors when trying to connect using windows authentication.Jeff |
|
|
|
|
|
|
service account change