Before you can connect to a database, you must create a server connection.
On the Database menu, click New Connection. The Database Connection Properties dialog box opens.
In the Server combo box, click Browse… The Browse for Servers window opens.
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.
Select the Authentication type.
Enter the login credentials in the User and Password fields.
In Database, type or click the name of the database which you want to connect to.
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.
(optional) You can assign a document category to the new connection.
(optional) You can click Advanced to configure advanced connection properties.
(optional) Click the Test Connection button to verify the connection.
Click OK to create the connection.