Cannot load drivers for SQL Server on WSO2 Data Services Server

Question

I am attempting to create a new Data Service in WSO2 Data Services Server to connect with SQL Server 2005. However, every time I test the connection I receive the error message "Driver class com.microsoft.jdbc.sqlserver.SQLServerDriver can not be loaded".

Data Source Type: RDBMS, Non-XA-DataSource
Database Engine: Microsoft SQL Server
Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver 
...

I don't believe my connection string or credentials are a problem as it fails on loading the driver.

What is the step that I'm missing in this process?

Answer 1

You have to put the Microsoft SQL driver jar inside repository/components/lib of DSS distribution in order to load the driver class.