I have tried many time to connect Pentaho CE to database in SQL Server 2005 but not successful. I first did this from Ubuntu on which Pentaho CE installed. It seems impossible to connect to SQL Server. I then installed Pentaho CE on the same machine with SQL Server and was following official guide to set it, failed.
The steps are:
- Download MS JDBC driver (version 4) and place it in
pentaho\bi-server\tomcat\webapps\pentaho\WEB-INF\lib and pentaho\administration-console\jdbc respectively
- after that, I go to Pentaho console to create a new data source and set everything as the manual said.
However, it always prompts that "No suitable driver for ..."
Does anybody meet this issue or could give a solution? Thanks in advance.