Connecting to a database

Before you can connect to a database, you must create a server connection.

To create a connection:

  1. On the Database menu, click New Connection. The Database Connection Properties dialog box opens.
  2. From the Server combo box, select the server you want to connect your database to.
  3. Select the Authentication type.
  4. Enter the login credentials in the Login and Password fields.
  5. In the Database combo box, type or click the name of the database which you want to connect to.
  6. In the Connection Name text box, the connection name should be generated automatically from the host name. You can create a distinctive name for your new connection.
  7. (optional) You can assign a document category to the new connection.
  8. (optional) Switch to the Advanced tab to configure additional connection properties.
  9. (optional) To verify the connection, click Test Connection.
  10. To create the connection, click OK.

Windows connection coloring

Window connection coloring allows you immediately to know which server you’re connected to. You can add coloring for each server connection in the Document Category field of the Database Connection Properties dialog box when setting the database connection properties.

Edit a database connection

To edit a database connection:

  1. In Database Explorer, right-click the connection you want to edit and select Modify Connection.
  2. In the Database Connection Properties window that opens, update the connection settings and click Ok.

Delete a database connection

To delete a database connection, in Database Explorer, right-click the connection you want to delete and select Delete.