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
... an special common place for we all, people who love Windows .NET framework development with Visual Studio 2010, enjoy and welcome, we all are waiting for your contributions! ...
Postings
-
Universidad Estatal de Georgia. This course shows an introduction in developing with C# programming language . With emphasis on development...
-
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 avo...
-
This section contains all the review items completed in February 25th 2011, for you my colleagues! Outline lectures Installing and Configu...
-
Fellow developers: Welcome home! I am really pleased of keeping in touch with you. Your expertise and comments are the richer way to grow u...
-
SQL Server Instances SQL Server Instances define the container of all tasks you can perform within SQL Server Platform. For each instance, ...
-
Installing and configuring SQL Server Instances In this review the following topics will be covered: Creation of service accounts In...
-
Microsoft Windows SQL Server 2008 Editions come with so many flavors oriented to different kind of clients and needs. It starts with SQL Ser...
-
Merry Xmas to everyone, have a very nice tech XP and personal development for the new 2012!
-
SQL Server Database Mail This feature enables a computer running SQL Server to send outbound mail messages. It can be used for sending mess...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment