My Microsoft MS SQL installation procedure and experience

Classic Servoy
1

Setting up MS SQL was not easy task for me. I thought I’ll share my installation procedures with you all. Sorry if this is duplicate info.

Servoy MS SQL Installation Instructions.

Assuming you have MS SQL server 2000 running on a windows 2000 domain and SQL server is already ADDED TO THE ACTIVE DIRECTORY (From enterprise manager, right click on your local database, go to properties–>Active directory–>click Add M-^Sadd this instance of SQL server to active directoryM-^T , with a test database set up, user name with proper permissions assigned.

Files needed:

  1. Download Servoy All in one installation package. (http://www.servoy.com)

Filename: servoy_installer.jar

  1. Download Sun Java TM SDK

https://sdlcweb1c.sun.com/ECom/EComActi … c0a8d4495c

Filename: j2sdk-1_4_2_04-windows-i586-p.exe

  1. Download Microsoft JDBC SQL drivers. Current at SP3

http://www.microsoft.com/downloads/deta … laylang=en

Filename: setup.exe

Installation:

  1. Install Sun Java TM SDK

Run j2sdk-1_4_2_04-windows-i586-p.exe

  1. Install Servoy All in one installation pacakge

Run servoy_installer.jar

  1. Install Microsoft JDBC SQL drivers

Run setup.exe

  1. Place the 3 crucial jar files into servoy directory

Search for msbase.jar, mssqlserver.jar, msutil.jar and place is in your

C:\program files\servoy\drivers directory

  1. Set up MS SQL as datasource in Servoy

Open Servoy–>Preferences–>DB servers

Server name: sqlservername_1234(DNS name)
User name: servoy (local username)
Password: servoy (local password)
Database Server URL: jdbc:microsoft:sqlserver://sqlservername-1234:1433;DatabaseName=servoytest1;SelectMethod=cursor

Few notes about the DATABASE SERVER URL that drove me nuts:

  1. the sqlservername, SERVOY DOES NOT LIKE “_” (underscores), change it to Dashs “-”. or make your server name without any dash or underscores at all.

  2. note also that the default for databasename has brackets “<>”, it keeps giving me log in errors. Take off brackets and it’ll work!

Leave everything else as default and click OK. You should be connected.

Hope this helps can save others time.

2
  1. note also that the default for databasename has brackets “<>”, it keeps giving me log in errors. Take off brackets and it’ll work!

Thanks the part that took me an hour.

3

The use of brackets is a common way to show what info has to filled in.

Like , , or , etc.
So you replace the whole word(s) with brackets.

Hope this helps.