Connecting to a Database

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

To create a connection:

  1. On the Start page click SQL Development and then click the New Connection button. 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, either SQL Server authentication or Windows authentication.
  5. Enter the login credentials in the User and Password fields.
  6. In Database, type or click the name of the database to which you want to connect.
  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. Click OK to create the connection.