MS SQL Server 2000 (Desktop Engine)

From WekaWiki

Table of contents

1 Installation 2 Testing 3 Troubleshooting 4 Links

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 (http://support.microsoft.com/default.aspx?scid=kb;en-us;313100) 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 (http://support.microsoft.com/default.aspx?scid=kb;en-us;313178) article
• Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
  For changing the authentication to mixed mode see this (http://support.microsoft.com/kb/319930/en-us) article

Links

• Microsoft SQL Server 2000 (Desktop Engine) http://www.microsoft.com/downloads/details.aspx?FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5
• Microsoft SQL Server 2000 JDBC Driver SP 3 http://www.microsoft.com/downloads/details.aspx?familyid=07287B11-0502-461A-B138-2AA54BFDC03A
• WEKA Mailing list https://list.scms.waikato.ac.nz/pipermail/wekalist/