How to find a server that is not connected in multi-server setup?

  • I have a large number of servers registered in my SSMS. I need to run a query on all of them with <multiple> connection.

    It displays an error "Cannot execute script. The server is not connected". How to find which one of them is not connected?

    Thanks.

  • Hi,
    if any of my servers ist not connected, I will see the servername in the tab "messages".
    Can you take a look and give some feedback.
    Kind regards,
    Andreas

  • I can see the tabs only when all connections were successful, and this was the case for the last several days. However today, again I see just a pop-up message "Cannot execute script. Additional information: The server is not connected. (SQLEditors)".

    If I click OK, it disappears but does not show the tabs.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply