Kettle 3.2 连接 SQL Server 2008
连接问题困扰两天，以前都没连过sql server 更不用说2008 的了，结果试验了两天，查询N久网络才查出来。
报错如下：
错误连接数据库 [查询库--目标库] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
Network error IOException: Connection refused: connect
org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
Network error IOException: Connection refused: connect
这个是 host name 不对
rg.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
Server WIN-11 has no instance named uyuu;.
org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
Server WIN-11 has no instance named jw_uyuu.
这个是instance不对。
最后的灵感来自：
java 连接：
连接串：jdbc:jtds:sqlserver://localhost:1433;instance=SQLEXPRESS;DatabaseName=test
或 jdbc:jtds:sqlserver://localhost:1433/test;instance=SQLEXPRESS
driverClassName="net.sourceforge.jtds.jdbc.Driver"
sql server中分instance和Database 在配置kettle时一定要注意。稍后专门的研究一下这个区别。
