Using basic capabilities : Overview of using basic capabilities : Creating and opening encyclopedias : SQL Server : Creating a connection
  
Creating a connection
The first step in creating any encyclopedia is to establish a connection. A connection serves as a pointer between your server and the encyclopedia that you are creating. First time users will not have any available connections. You'll need to create a new connection and specify the Server Name , Server Type and Security. When creating a connection use the preferred name of the server connection. To create a Connection, perform the following steps:
1 In System Architect, click File > Open Encyclopedia (or click the Open Encyclopedia toolbar button).
2 Click the New icon.
3 Click the ... (ellipsis) button next to the Connection field.
The Connection Manager dialog appears.
4 Click the New icon in the Connection Manager dialog.
5 Specify a name for the connection in the Connection Name field, preferably the same as the server name.
6 Select your server from the Server Name list.
7 Select the type of server in the Server Type list.
8 Select the type of Security you are using: Windows, SQL Server or SQL (Persist Password).
If you are running SQL Express on your local computer, then you can use Windows Security for Windows 2000, Windows 2003, and Windows XP machines.
9 Click OK.
See also
SQL Server