Installation

  • Download the Desktop Engine (see Links)
  • Extract the files by running the downloaded executable
  • Edit the setup.ini file and add a strong password for the sa account:
 SAPWD=*password*

Note: the default password is empty, which can prevent the setup from continuing the installation

  • Run the setup

Testing

  • This article lists Java code for testing the connection

Troubleshooting

  • Error Establishing Socket with JDBC Driver

    Add TCP/IP to the list of protocols as stated in this article

  • Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

    For changing the authentication to mixed mode see this article