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 Enable SQL Server Native Client Protocols

To enable a protocol right click the Protocol and then select Enable option from the drop down list.

SQL Server Native Client Protocols
SQL Server Native Client Protocols


How to Disable SQL Server Native Client Protocols

To disable a Protocol right click the protocol and then select Disable option from the drop down list.

Using SQL Server Configuration Manger you can also force protocol encryption, it also allows you to create or remove alias.

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



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.