SQL Server Performance, DBA Best Practices & Enterprise Data Solutions | MyTechMantra
FacebookXPinterestEmailGoogle+LinkedInWhatsApp
DBADevelopersSQL Server

How to Use SQL Server Configuration Manager

Ashish Kumar Mehta
6 min read

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.


Error: Your Requested widget " arpw-widget-2" is not in the widget list.
  • [do_widget_area gridlove_default_sidebar]
    • [do_widget_area gridlove_default_sticky_sidebar]
      • [do_widget id="mks_ads_widget-22"]
    • [do_widget_area gridlove_footer_sidebar_1]
      • [do_widget id="text-3"]
      • [do_widget id="mks_social_widget-3"]
    • [do_widget_area gridlove_footer_sidebar_2]
      • [do_widget id="text-4"]
    • [do_widget_area gridlove_footer_sidebar_3]
      • [do_widget id="nav_menu-1"]
    • [do_widget_area gridlove_footer_sidebar_4]
      • [do_widget id="text-5"]
    • [do_widget_area gridlove_header_sidebar]
      • [do_widget id="mks_social_widget-1"]
      • [do_widget id="gridlove_posts_widget-3"]
    • [do_widget_area gridlove_sidebar_1]
      • [do_widget id="mks_social_widget-4"]
    • [do_widget_area gridlove_sidebar_2]
      • [do_widget_area gridlove_sidebar_3]
        • [do_widget_area gridlove_sidebar_4]
          • [do_widget_area gridlove_sidebar_6]
            • [do_widget_area gridlove_sidebar_7]
              • [do_widget_area widgets_for_shortcodes]
                • [do_widget id="arpw-widget-2"]
                • [do_widget id="text-6"]
                • [do_widget id="mks_ads_widget-11"]
                • [do_widget id="mks_ads_widget-13"]
                • [do_widget id="mks_ads_widget-15"]
              • [do_widget_area wp_inactive_widgets]
                • [do_widget id="custom_html-2"]
                • [do_widget id="gridlove_posts_widget-2"]
                • [do_widget id="gridlove_posts_widget-7"]
                • [do_widget id="gridlove_posts_widget-6"]
                • [do_widget id="custom_html-3"]

              1 2 3 4 5

              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.

              View all posts

              You may also like

              Follow us

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