Connection Status

Some client tools may not clearly indicate connection status. A failed command is your first indication that the connection does not exist.

A quick way to confirm the connection is by querying the database name.

To display the current database, use this syntax:
select db_name()
To specify a different database, use this syntax:
select db_name([ database_id ])