June 25, 2014 at 10:50 am
Hi - I've been advised that when a SQL service needs to be stopped or started this should be done through configuration manager & not Windows Services. Can someone please explain to me the reason for this?
Any answers will be very much appreciated.
Many thanks
Dax
June 25, 2014 at 11:02 am
This is from BOL:
Important note Important
Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings. Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. If the service cannot access the SQL Server portion of the registry the service may not start properly.
That is the main reason why you should use Configuration Manager, but it is a good habit to have to start and stop the services too.
June 26, 2014 at 3:04 am
That's great, many thanks for the reply
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply