I'm trying to connect my Pentaho user console to MS SQL Server 2000. However, I always get this error:
Error connecting to database [sps]:
org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database:(using class
com.microsoft.sqlserver.jdbc.SQLServerDriver)
Invalid URL:jdbc:sqlserver://172.16.1.134:1433;databaseName=sys_v2;
integratedSecurity=false;user=sa;pass
Can anyone tell me why I get this error & how to solve it? TQ