MS+SQL+Server+2000+(Desktop+Engine)

toc

= Installation = code format="text" SAPWD=//password// code > Note: the default password is empty, which can prevent the setup from continuing the 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:
 * Run the setup

= Testing =
 * [|This] article lists Java code for testing the connection

= Troubleshooting = > Add TCP/IP to the list of protocols as stated in [|this] article > For changing the authentication to mixed mode see [|this] article
 * **Error Establishing Socket with JDBC Driver**
 * **Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.**

 = Links =
 * [|Microsoft SQL Server 2000 (Desktop Engine)]
 * [|Microsoft SQL Server 2000 JDBC Driver SP 3]