SQL Server Performance, DBA Best Practices & Enterprise Data Solutions | MyTechMantra

How to Use 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.


How to Force Protocol Encryption in SQL Server

To configure force protocol encryption, expand SQL Server Network Configuration and then right click Protocols for <INSTANCE> and then select Properties.

To turn on Force Encryption select the option Yes from the drop down list and click OK to save the changes.



Conclusion

In this article you have seen how easily one can configure Network / Client Protocols, can change service accounts or can update service account passwords using SQL Server Configuration Manager.

Ashish Kumar Mehta

Ashish Kumar Mehta is a distinguished Database Architect, Manager, and Technical Author with over two decades of hands-on IT experience. A recognized expert in the SQL Server ecosystem, Ashish’s expertise spans the entire evolution of the platform—from SQL Server 2000 to the cutting-edge SQL Server 2025.

Throughout his career, Ashish has authored 500+ technical articles across leading technology portals, establishing himself as a global voice in Database Administration (DBA), performance tuning, and cloud-native database modernization. His deep technical mastery extends beyond on-premises environments into the cloud, with a specialized focus on Google Cloud (GCP), AWS, and PostgreSQL.

As a consultant and project lead, he has architected and delivered high-stakes database infrastructure, data warehousing, and global migration projects for industry giants, including Microsoft, Hewlett-Packard (HP), Cognizant, and Centrica PLC (UK) / British Gas.

Ashish holds a degree in Computer Science Engineering and maintains an elite tier of industry certifications, including MCITP (Database Administrator), MCDBA (SQL Server 2000), and MCTS. His unique "Mantra" approach to technical training and documentation continues to help thousands of DBAs worldwide navigate the complexities of modern database management.

Follow us

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