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时一定要注意。稍后专门的研究一下这个区别。


[img]http://dl.iteye.com/upload/attachment/512309/03328a10-3b4c-334e-a931-9d69fb8efd7f.jpg[/img]