1. Download and install the free JDBC driver
a. Download the files from: http://www.microsoft.com/sql/downloads/jdbcregister.asp
b. Locate the following files in the download: msbase.jar, msutil.jar and mssqlserver.jar, place those files in the Drivers directory inside the main Servoy directory.
2. Under the Edit menu, choose Preferences, go to the DB Servers tab. In the "Auto Setup Server" pulldown choose "MS SQL", this will prefill most of the required values for you. Fill in a server name and fill in the username and password. Now make the following adjustments to the Database Server URL:
-replace localhost with the name or ip of the sql server (if necessary)
-replace 1433 with the portnumber the sql server listens on (if necessary)
-replace <database_name> with the name of the database you want to connect to
3. Click OK. If you see no error you are able to establish a connection with the database. If you get an error click on details, if you're unable to resolve the error please post what errors you get on the forum or contact support@servoy.com