Step By Step Installation SQL2005

Classic Servoy
1

Step 1. Download Servoy
Step 2. Install
Step 3. Get jtds-1.2.2.zip from Sourceforge
Step 4. Delete any other jtds drivers in C:\Program Files\Servoy\drivers
Step 5.
Extract only jtds-1.2.2.jar file from this zip and place it in following directory:
C:\Program Files\Servoy\drivers

Step 6. In MSSQL2005, create two blank databases. One for your repository and one for your development.
Step 7. Run Servoy Developer (Ignore Errors)
Step 8. Go to Edit Preferences
Step 9.

Double click repository_server and edit following lines as follows

  1. Leave name repository_server.

  2. Username - sa etc.

  3. Your password

  4. Database Server URL: jdbc:jtds:sqlserver://Your ServerName/DatabaseName

  5. Driver: net.sourceforge.jtds.jdbc.Driver

This is your Repository database.

Step 10.

Click New to create new server entry and edit following lines as follows

  1. Enter Servername

  2. Username - sa etc.

  3. Your password

  4. Database Server URL: jdbc:jtds:sqlserver://Your ServerName/DatabaseName

  5. Driver: net.sourceforge.jtds.jdbc.Driver

This is your Development database.

Step 11.
Restart Servoy after entries above.
Step 12.
When you restart Servoy, it will ask you to create a repository. Click Yes and then you can use the application.

Please correct me if there any mistakes or omissions and thanks for your help in getting me all up and running here.

Sull

2 
Step 4. Delete all drivers in C:\Program Files\Servoy\drivers

I would change that to "delete any other jtds drivers in C:\Program Files\Servoy\drivers"
Because you might want/need to connect to other RDBMSs as well.

Hope this helps.

Edit: fixed a typo

3

Thanks Robert. Have done so.

New to development myself so hopefully the above will help someone else out.

4

I am sure it will be of help. Over time we tend to think that certain things are obvious but that is not always the case.
So thank you for this clear list!