Error when trying to connect MS SQL Server 2005

[Anonymous]

When I configure the MS SQL Server connection I have this error :
"I/O ErrorSO Failed: Native SSPI library not loaded. Check the java.library.path system property"
I still have the same problem in MS SQL Server Management Studio Express when I need to see Properties for a table in a Database.
Thank you for your help...

[Anonymous]

Obviously to local SQL server on my laptop...
I tried:
Login: Dan
Password:
Server: LAPTOP_ELQ2Q8QT
Port: 1433
Database: test
Schema:
Additional Parameters: instance=SQLEXPRESS
and this
Login: Dan
Password:
Server: LAPTOP_ELQ2Q8QT
Port: 1433
Database: test
Schema:
and this
Login: Dan
Password:
Server: localhost
Port: 1433
Database: test
Schema:
I attached the login I use in MS SQL server management studio

[Anonymous]

Hi,
Could you please try to use:
Login: Dan
Password:
Server: localhost
Port: 1433
Database: test
Schema: 
Additional Parameters: instance=SQLEXPRESS and check if  nlmauth.dll is placed in the JRE\bin directory?
Can you use  SQL Server authentication to connect your sql server 2012 successfully? We cannot repro your issue on our side.
Best regards
Sabrina

[Anonymous]

Connection failure. You must change the Database Settings.
  java.lang.RuntimeException: java.sql.SQLException: Network error IOException: Connection refused: connect
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1092)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$59.runWithCancel(DatabaseForm.java:3812)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$59.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
  Caused by: java.sql.SQLException: Network error IOException: Connection refused: connect
      at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:436)
      at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
      at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
      ... 9 more
  Caused by: java.net.ConnectException: Connection refused: connect
      at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
      at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
      at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
      at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
      at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
      at java.net.PlainSocketImpl.connect(Unknown Source)
      at java.net.SocksSocketImpl.connect(Unknown Source)
      at java.net.Socket.connect(Unknown Source)
      at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
      at net.sourceforge.jtds.jdbc.SharedSocket.(SharedSocket.java:251)
      at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:331)
      ... 12 more
 Getting this error while connection to MS SQL Server with Talend. Need help.

[Anonymous]

Hi ptlvsl,
Can you successfully connect your MS SQL Server through client without using talend tool?
Best regards
Sabrina

[Anonymous]

Make sure :

1) SQL BROWSER is enabled in services

2) Protocols for sqlexpress or whatever instance you are  using is enable in sql configuration manager.