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. In the Server combo box, click . The **Browse for Servers window** opens.
  3. On the Local Servers tab, select an SQL Server instance (if any). Otherwise, click the Network Servers tab to select an SQL Server instance in the network.
  4. Select the Authentication type.
  5. Enter the login credentials in the User and assword fields.
  6. In Database, type or click the name of the database which you want to connect to.
  7. 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.
  8. (optional) You can assign a document category to the new connection.
  9. (optional) You can click Advanced to configure advanced connection properties.
  10. (optional) Click the Test Connection button to verify the connection.
  11. Click OK to create the connection.

Windows connection coloring

Window connection coloring allows you immediately to know to 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 an already existing database connection, on the Database menu, click Connection Manager. The Connection Manager dialog box opens. Select a required connection, and then click the Edit button. The Database Connection Properties dialog box opens where you can make changes on database connection parameters.

Delete a database connection

To delete a database connection, open Connection Manager on the Database menu. Choose a connection you want to delete, and then click the Delete button.