Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] sql server 2008 R1 connection issues

hey,
I've been trying to connect with sql server 2008 but I couldn't, and I'm getting  exception... 
  
and it says that : I have to check if the TCP port are not blocked with a firewall...  well, no it's not !
what should I do ???
Echec de la connexion Vous devez modifier les paramètres de la base de données.
  java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Échec de la connexion TCP/IP à l'hôte (local), port 1433. Erreur : « null. Vérifiez les propriétés de connexion. Assurez-vous qu'une instance de SQL Server est en cours d'exécution sur l'hôte et accepte les connexions TCP/IP au port. Vérifiez que les connexions TCP au port ne sont pas bloquées par un pare-feu. ».
      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$62.runWithCancel(DatabaseForm.java:3953)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.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: com.microsoft.sqlserver.jdbc.SQLServerException: Échec de la connexion TCP/IP à l'hôte (local), port 1433. Erreur : « null. Vérifiez les propriétés de connexion. Assurez-vous qu'une instance de SQL Server est en cours d'exécution sur l'hôte et accepte les connexions TCP/IP au port. Vérifiez que les connexions TCP au port ne sont pas bloquées par un pare-feu. ».
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
      at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
      at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
      at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
      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
Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

hello Sabrina,
problem resolved  0683p000009MACn.png , 
 Talend and SQL server are in the same machine so...
how I did it: on Sql server 
1 - server type :    database engine
2- server name :   127.0.0.1 
3- Authentication : Sql Server authentication
4- login :              sa
5- password :        *****   (any password you want )
then, on Talend:
I did put the same specifications    ( specially the pass and login name)
thanks for your help Sabrina
cordialement 

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Hi,
Can you successfully connect to your sql server 2008 through client without using talend tool?
Best regards
Sabrina
Anonymous
Not applicable
Author

hello Sabrina,
problem resolved  0683p000009MACn.png , 
 Talend and SQL server are in the same machine so...
how I did it: on Sql server 
1 - server type :    database engine
2- server name :   127.0.0.1 
3- Authentication : Sql Server authentication
4- login :              sa
5- password :        *****   (any password you want )
then, on Talend:
I did put the same specifications    ( specially the pass and login name)
thanks for your help Sabrina
cordialement 
Anonymous
Not applicable
Author

Hi,
Great this issue has been fixed by yourself. Feel free to let us know if there is any further help we can give.
Best regards
Sabrina