If you want to check if SQL server is still running on the host you're checking, you can use the SQL server checking of Servers Alive.
Servers Alive can go a bit further and check if a specific database is still running too. Therefore you need to enter the appropriate names into the GUI.

Servers Alive will check the SQL server using SQL DMO. Therefore you must have a SQL server client installed on the machine that is running Servers Alive (installing ISQL/W is enough). Also you must have SQL DMO installed on the SQL server itself (the default installation of SQL server installs this!)
SQL server will see this checking as being a normal connection to SQL server, therefore you must have the need client licenses to do this. For more info on the client licenses for SQL server you can always contact your local Microsoft representative.

With the CHECK DB button you can see if the settings you enter are correct or not.
What returns can Servers Alive get from the server and what do they mean?
4002 Login failed.
10004 No connection possible.
18458 Login failed - Max number of user connections.
21511 No SQL DMO lib's installed on server.


Copyright © Woodstone Computer Consulting 1997