[resolved] sql server 2008 R1 connection issues

Anonymous — Sat, 04 Feb 2017 07:45:19 GMT

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

Re: [resolved] sql server 2008 R1 connection issues

Anonymous — Mon, 06 Feb 2017 02:54:18 GMT

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

Re: [resolved] sql server 2008 R1 connection issues

Anonymous — Mon, 06 Feb 2017 17:05:19 GMT

hello Sabrina,
problem resolved ,
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

Re: [resolved] sql server 2008 R1 connection issues

Anonymous — Tue, 07 Feb 2017 02:02:55 GMT

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

topic [resolved] sql server 2008 R1 connection issues in Talend Studio

[resolved] sql server 2008 R1 connection issues

Re: [resolved] sql server 2008 R1 connection issues

Re: [resolved] sql server 2008 R1 connection issues

Re: [resolved] sql server 2008 R1 connection issues