SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com

SQL Server Configuration Manager

Click here to read “How to Use SQL Server Configuration Manager to Manage SQL Server Services, Configure Network Protocols, and Network Connectivity Configuration” article from the beginning.

Why one should Use SQL Server Configuration Manager to Change SQL Server Service Account or to Change Password?

Database Administrator should always use SQL Server Configuration Manager Tool to change SQL Server Service Account or to change the password for any of the SQL Server Services.

The biggest advantage is; it performs additional configurations such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings immediately once it is changed using SQL Server Configuration Manager or SQL Server Management Objects (SMO) or using Window Management Instrumentation (WMI). The other advantage is it will come into effect immediately without the need to restart the SQL Server Service thereby helping you avoiding the downtime. Hence, you should always avoid the practice of changing the SQL Server Services account or changing password using SERVICES.MSC.

Learn Database Backup Encryption in SQL Server 2014 a Step by Step Implementation Guide

Managing SQL Server and Client Network Protocols

Database Administrator can use SQL Server Configuration Manager to configure server and client network protocols and also to change the connectivity options.

SQL Server Configuration Manager
SQL Server Configuration Manager

Supported SQL Server Network and Client Protocols

Microsoft SQL Server 2005 and higher versions support below mentioned network and client protocols.

1. Shared Memory
2. Named Pipes
3. TCP/IP
4. VIA

Important Note: The VIA protocol is deprecated in Microsoft SQL Server 2008 and it will be removed in the future versions of Microsoft SQL Server, hence avoid using it in future development.

Click the below Number Buttons to continue reading the rest of the article.

Ashish Mehta

Ashish Mehta

Ashish Kumar Mehta is a database manager, trainer and technical author. He has more than a decade of IT experience in database administration, performance tuning, database development and technical training on Microsoft SQL Server from SQL Server 2000 to SQL Server 2014. Ashish has authored more than 325 technical articles on SQL Server across leading SQL Server technology portals. Over the last few years, he has also developed and delivered many successful projects in database infrastructure; data warehouse and business intelligence; database migration; and upgrade projects for companies such as Hewlett-Packard, Microsoft, Cognizant and Centrica PLC, UK. He holds an engineering degree in computer science and industry standard certifications from Microsoft including MCITP Database Administrator 2005/2008, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

Newsletter Signup! Join 15,000+ Professionals




Be Social! Like & Follow Us...

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.

Recent SQL Server Tips

Manning