Connecting to a Running Database on a Local Server

When the database is already running on a local server, you may specify fewer Connect dialog parameters than usual.

  1. Start Interactive SQL and open the Connect dialog, if it does not appear automatically.
  2. On the Identification tab, enter a user ID and a password.
  3. Do one of the following:
    • If the server contains only one database, click OK to connect to it.
    • If the server contains multiple databases, click the Database tab and specify a database name. This is usually the database file name, without the path or extension.
Note: If the database is already loaded (started) on the server, you need only provide a database name for a successful connection. The database file is unnecessary.