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 ......