Delete invalid SQL Server Registration

Source: Internet
Author: User
If sqlserver is often used, multiple registrations will be established in the Enterprise Manager, so that sqlserver on other computers do not need to be remotely. In this way, the management of several databases is indeed more convenient.
However, there will still be depressing things. If you have registered n sqlserver instances in the Enterprise Manager, the problem may occur one day when those sqlserver servers change their IP addresses or are inaccessible for other reasons. If you click on the Enterprise Manager and cannot connect to sqlserver, you may only have crashed. Those SQL servers that cannot be connected there always seem uncomfortable and want to delete them. However, as long as you click the mouse, the system does not respond and there is no way to delete it.

I was recently tortured by this problem for a while, and then made up my mind to find a solution. And Google. It is found that there is a more effective method, at least those SQL servers that cannot be connected to me have been deleted.

Click that cannot be connected with the mouse (isn't it going to crash? Is the system unresponsive? What are you doing? Don't worry, look down), press quickly,Alt +(That is, open the operation menu), and then pressDKey (that is, to open the menu for deleting SQL Server registration. Of course you cannot see those menus. If the system does not respond, it cannot be displayed, but the system still executes your shortcut key). The next step is to wait (depending on the situation, it should take a few seconds ). Then, a window is displayed to determine whether to delete the object. Click OK.

If this happens to you, try again ......

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.