How to configure Manager in SQL Server
This article is to share with you about how to configure the manager in SQL Server, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.
SQL Server 2005 introduces SQL Server configuration Manager (SQL Server Configuration Manager), which is used to manage services associated with SQL server, configure network protocols used by SQL Server, and configure SQL Serveer clients. It integrates the functions of SQL server 2000 server and client network utilities, service manager and other tools to start, pause, resume or stop services and view or change service properties.
The SQL Server configuration Manager starts by clicking the "start"-"programs"-Microsoft SQL Server 2005-SQL Server Configuration Manager command, as shown in figure 1 (you can see that the rationing tool includes multiple configuration sets), and opens the SQL Server configuration Manager dialog box, as shown in figure 2. The SQL Server configuration Manager mainly includes the following features:
Startup of SQL Server configuration Manager
1) manage services. Use SQL Server configuration Manager to start, pause, resume, or stop services, and to view or change service properties.
2) change the account used by the service. Use SQL Server configuration Manager to manage SQL Server services.
3) manage server and client network protocols. Use SQL Server configuration Manager to configure server and client network protocols and connection options. You can manage server and client network protocols, including features such as forcing protocol encryption, enabling and disabling network protocols, viewing alias properties, or enabling / disabling protocols. You can create or delete aliases, change the order in which protocols are used, or view the properties of server aliases.
The above is how to configure the manager in SQL Server. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.
