 | As of Razuna 1.4 you don't need to apply these steps anymore. Razuna configures itself for your database! |
Configure a datasource for MSSQL
Razuna is based on the OpenBD CFML (ColdFusion) open source engine. The engine itself comes with a administration section of its own, which lets you configure different parts of the engine itself.
WARNING: Any changes to the engine, other then the ones shown here, and resulting in failure of Razuna do not entitle you for any free support of alike. This is meant for people who know what they do! If you are not sure, please contact us or get your administrator to help you!
Access the Administration
The OpenBD Administration can be found at http://localhost:8080/bluedragon/administrator/ (of course enter here the domain you use to access Razuna). You will then see a login screen. Enter "admin" (unless you have changed the password, which you should have!).
Modifying or adding a new datasource
The datasource settings can be found in the left navigation. Click on it and you should get a list of datasources. By default there should be the most used ones listed. Click on the "pencil" icon to edit the MSSQL one.
If there is no MSSQL datasource then add one by using the name "MSSQL" and the choosing the jTDS MSSQL Driver from the drop down menu. Then click on "Add Datasource".
Changing the MSSQL datasource
When you add or edit a datasource you will be taken to the "Configure Datasource" screen (as shown in the screen shot). Change the values according to your setup:
OpenBD Datasource Name: This is the name you give to the datasource. This is the same name as you should use in the config file.
Database Name: This should be "razuna".
Database Server: The address to your MSSQL Server.
Server Port: Unless you changed it from the default MSSQL installation port, you should change this value.
User Name: Enter your username.
Password: Enter your password.
There is nothing else you need to change here, except clicking on "Submit" to save your changes. The Administration will now check your values and if it can connect successfully to the MSSQL database and server you will get notified of the successful connect.
Troubleshooting
If your connection fails, please check that all values have been entered correctly (especially the FireWall, if any in place, lets you connect to the MSSQL server) and that you enabled SQL Auth in MS SQL (Windows Auth will not work!).
Another issue could be that you don't have TCP/IP enable in your MSSQL Server. To enable it, simply go to your MSSQL Server Configuration application and enable TCP/IP connection according to the screen shot below.
Don't go any further unless you successfully connected to your MSSQL Server!