Native Connection to SQL Server Repository

Keyboard Shortcuts

Ctrl+O : Connect to Server

Other

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

| Open Project : Connect to Server

Start Page : Manage Projects : Connect to Server

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.