Prev Next

Native Connection to SQL Server Repository

In most installations users will be able to create native connections to SQL Server databases without the need to install or configure any other software.

Prerequisites

  • A SQL Server database server
  • A Enterprise Architect repository defined in the SQL Server database server
  • You know the database user credentials that have SELECT, INSERT, UPDATE, DELETE, EXECUTE and SHOW VIEW access permissions to the Enterprise Architect repository

Access

Keyboard Shortcuts

Ctrl+O : Connect to Server

Other

Start Page | Server Connection (direct to 'Open Server Connection' dialog)

Project list | Open Project : Connect to Server

Start Page : Manage Projects : Connect to Server

Connect to Repository

Step

Action

See also

1

In Enterprise Architect, open the 'Open Server Connection' screen ('Project list | Open Project : Connect to Server' ribbon option).

2

Select the SQL Server option

3

Fill in the details of the database, including Server Name, Port, Database Name and optionally Database User and Password.

Note: to use Windows Authentication (or Integrated Authentication) simply leave both the User and Password fields empty. Entering a User and Password will imply that the connection will use SQL Server Authentication.

4

Enterprise Architect Native connection to SQL Server has the ability to make use of either the OLEDB or ODBC drivers, the option you choose will depend on the drivers installed on your machine

The Use strong encryption for data and Trust server certificate extended options  are only visible for the OLEDB driver type and relate to how the underlying database driver will communication to the database server.

5

Click the [Test] button.  A "Connection Successful" popup message should be displayed, including a summary of the server's version details.

If the connection is not successful, the message should include a hint or reason why it failed, the reason(s) listed will need to be corrected before continuing.

Note:

Minimum requirements:

  • Windows 7 SP1
  • KB3140245 (for TLS defaults)
  • KB4474419 (for SHA-2 support)
  • KB4490628 (for SHA-2 support)

6

Once step 5 succeeds the OK button will be enabled, click [OK] to open the repository.

Notes

  • Connecting to DBMS based Repositories is available in the Corporate, Unified and Ultimate Editions of Enterprise Architect
  • Depending

Learn more