Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Service startup/shutdown - Windows or Configuration Manager? Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2014 10:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:44 AM
Points: 27, Visits: 79
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
Post #1586010
Posted Wednesday, June 25, 2014 11:02 AM This worked for the OP Answer marked as solution


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:29 PM
Points: 588, Visits: 900
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.




Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1586011
Posted Thursday, June 26, 2014 3:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:44 AM
Points: 27, Visits: 79
That's great, many thanks for the reply
Post #1586302
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse