SQLSERVER连接报错处理办法

防火墙拦截提示
Connection reset ClientConnectionId:bed67405-14a2-4021-b1af-8fedd07cf693
  Connection reset
Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed.
I/O Error: Connection reset
  • 处理办法：检查是否开启局域网访问；关闭防火墙或放开数据库端口
测试数据库连接提示
错误连接数据库 [mssql] : org.pentaho.di.core.exception.KettleDatabaseException: 
Error occurred while trying to connect to the database

Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed.
net.sourceforge.jtds.jdbc.Driver
  • 处理办法：下载 JTDS 驱动包，将压缩包中的 jtds-1.3.1.jar 文件放入tomcat/lib目录，重启kettle-pack-tomcat服务