开发者

JNDI exmple for connecting to a named instance of MsSQL

开发者 https://www.devze.com 2023-03-26 19:37 出处：网络

We\'re using Pentaho Data I开发者_JS百科ntegration(Open source ETL tool) and are trying to use a JNDI connection to connect to a MS SQL 2005 database.If we use a default instance on the server it work

相关专题：jndi kettle pentaho-data-integration sql-server-2005

We're using Pentaho Data I开发者_JS百科ntegration(Open source ETL tool) and are trying to use a JNDI connection to connect to a MS SQL 2005 database. If we use a default instance on the server it worked fine, however issue that we are having is trying to get it to connect to a named instance.

If you could provide an example or somewhere to look we'd be grateful.

Thanks.

Because Microsoft recommends that you run named instances on different ports, they decided to completely ignore the named instance when you include the port number.

Therefore you can either drop the port number and append the named instance, e.g. hostname\instance or again drop the port number and use the property instanceName=myinstance.

Not sure how this translates to JNDI but we have been successful using this in Spoon with the SQL Server JDBC driver and integrated windows security.