Here I am (again) to let you know something that most of you probably know much better than me.
This little suggestion helps a lot for avoiding so many mistakes and hard times...
If you need to do "any" configuration task remember to use SQL Server Congifuration Manager, it does integrate all you need to start, pause, stop, restart, a SQL Server Service, and also you can do your regular administration task thru it. For example, you will need to change password accounts regularly, but you don´t want to stop, or even restart SQL Server each time you do your security maintenance tasks. If you use SQL Server Configuration Manager you can change the password of SQL Server Service Accounts with no longer need to restart the SQL Server Instance. All theses changes are available inmediately...
Warning: You should never, ever use Windows Service applet again to do these jobs. It will give you very hard times. Every time you change a password there, you will be forced to restart your SQL Server Instance again, so compromising your production environment availability... take it easy and remember "SQL Server Configuration Manager" always!
Good luck folks
Jaime Gibertoni
No comments:
Post a Comment