Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to close SQLServer2005 remote connection and other external services". In daily operation, I believe many people have doubts about how to close SQLServer2005 remote connection and other external services. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to close SQLServer2005 remote connections and other external services". Next, please follow the editor to study!

How to close SQLServer2005 remote connection and other external services

1. Use firewalls to prevent external services. (I won't say much about this.)

two。 Shut down the SQLServer2005 external service:

1 >. Point to start-> programs-> MicrosoftSQLServer2005- > configuration tools-> SQLServer Peripheral Application Configurator

2 >. On the SQLServer2005 Peripheral Application Configurator page, click Peripheral Application Configurator for Services and connections

3 >. Then click to expand databaseengine (Database engine), select remote connections, and select Local connections only on the right.

Click apply, and you will see the following message: "changes to the connection settings will not take effect until the database engine service is restarted." Click the OK button to return to

How to close SQLServer2005 remote connection and other external services

4 >. Expand the Database engine, select Services, click stop on the right, wait until the MSSQLSERVER service stops, and then click start to restart the MSSQLSERVER service.

3. Turn off the SQLServer browser service:

1 >. Point to start-> programs-> MicrosoftSQLServer2005- > configuration tools-> SQLServer Peripheral Application Configurator

2 >. On the SQLServer2005 Peripheral Application Configurator page, click Peripheral Application Configurator for Services and connections

3 >. Then click to expand SQLServerBrowser, select Services, select disable on the right Startup Type, click stop, and click OK to return.

At this point, the study on "how to close SQLServer2005 remote connections and other external services" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.