Prev Next

Connect to a SQL Server Repository

After you have created a Microsoft SQL Server database, you can connect to it immediately without any further configuration directly from Enterprise Architect.

Prerequisites

  • The Microsoft SQL Server database/repository already exists and you know the details
  • You have the details of a database user with the required permissions within the database, see SQL Server Security Permissions
  • Microsoft SQL Server OLE DB driver

Access

Ribbon

Project list: Open Project

Keyboard Shortcuts

Ctrl+O

Connect to the repository

Step

Action

1

In the 'Open Project' dialog, select the 'Connect to Server' checkbox.

2

Click on the Browse. button.

The 'Data Link Properties' dialog displays.

3

Select 'Microsoft OLE DB Provider for SQL Server' or 'Microsoft OLE DB Driver for SQL Server' from the list.

Note:

  • 'Microsoft OLE DB Provider for SQL Server' is usually part of the Windows Operating System, otherwise it can be installed as part of MDAC 2.8.
  • 'Microsoft OLE DB Driver for SQL Server' is a newly released driver that adds support for TLS v1.2 and other more recent features of Microsoft SQL Server (like multi-subnet failover capabilities). This driver is available from the Microsoft website.

4

Click on the Next>> button.

The 'Connection' tab displays.

5

Type in the server details, including Server Name, User Name and Password.

6

Click on the 'Select the database on the server' option and on the drop-down arrow.

From the list, select the project to connect to.

7

Click on the Test Connection button to confirm that the details are correct.

8

If the test does not succeed, revise your settings.

If the test succeeds, click on the OK button; the 'Connection Name & Type' dialog displays.

9

Give the connection a suitable name so that you can recognize it in the 'Recent Projects' panel on the 'Open Project' dialog.

10

If required, select the 'Encrypt Connection String' checkbox.

This encrypts and hides the connection details of the database from the users that the connection string is given to.

11

If required, select the 'Lazy Load' checkbox to not load the full project view when the model is loaded; instead, only the parts that are necessary to display the visible portion of the tree are loaded.

With this setting, the model loads faster and users can begin work sooner, but at the expense of later small delays as Enterprise Architect loads specific portions of the model.

12

If required, select the 'Use WAN Optimization' checkbox.

Note: this option is only included for historical reasons, the WAN Optimizer product has been replaced by the vastly improved Pro Cloud Server.

The WAN Optimizer was originally created to improve performance over a Wide Area Network by compressing all database requests from Enterprise Architect to reducing transfer times.

If you select this checkbox, complete the next two fields (see your administrator for the correct values); otherwise go to step 15.

13

In the 'Server' field, type the network name or address of the optimizer server.

14

In the 'Port' field, type the port on which the server is running on the remote machine.

15

Click on the OK button to complete the configuration and open the project.

This also adds the project name to the 'Recent' list on the Start Page; from now on, you can open the project again just by clicking on this name.

Notes

  • Connecting to DBMS based Repositories is available in the Corporate, Unified and Ultimate editions

Learn more