Setup a SQL Server connexion

Anonymous — Wed, 15 Oct 2014 06:26:40 GMT

Hello
I have the following erreur when I try to setup a SQL server connexion:
Echec de la connexion Vous devez modifier les paramètres de la base de données.
java.lang.RuntimeException: java.sql.SQLException: Échec de l'ouverture de session de l'utilisateur 'dhonore'.
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:177)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1047)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:301)
      at org.talend.repository.ui.utils.ManagerConnection.check(ManagerConnection.java:261)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.checkConnection(DatabaseForm.java:2096)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.access$41(DatabaseForm.java:2021)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$24.widgetSelected(DatabaseForm.java:2349)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
      at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
      at org.eclipse.jface.window.Window.open(Window.java:801)
      at org.talend.repository.ui.actions.metadata.CreateConnectionAction.doRun(CreateConnectionAction.java:207)
      at org.talend.repository.ui.actions.AContextualAction$2.run(AContextualAction.java:617)
      at org.talend.repository.RepositoryWorkUnit.executeRun(RepositoryWorkUnit.java:93)
      at org.talend.core.repository.model.AbstractRepositoryFactory.executeRepositoryWorkUnit(AbstractRepositoryFactory.java:237)
      at org.talend.repository.localprovider.model.LocalRepositoryFactory.executeRepositoryWorkUnit(LocalRepositoryFactory.java:3212)
      at org.talend.core.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(ProxyRepositoryFactory.java:1979)
      at org.talend.repository.ui.actions.AContextualAction.run(AContextualAction.java:626)
      at org.talend.repository.viewer.action.RepoDoubleClickAction.run(RepoDoubleClickAction.java:112)
      at org.eclipse.ui.actions.RetargetAction.run(RetargetAction.java:221)
      at org.eclipse.ui.navigator.CommonNavigatorManager$3.open(CommonNavigatorManager.java:185)
      at org.eclipse.ui.OpenAndLinkWithEditorHelper$InternalListener.open(OpenAndLinkWithEditorHelper.java:48)
      at org.eclipse.jface.viewers.StructuredViewer$2.run(StructuredViewer.java:845)
      at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
      at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)
      at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
      at org.eclipse.jface.viewers.StructuredViewer.fireOpen(StructuredViewer.java:843)
      at org.eclipse.jface.viewers.StructuredViewer.handleOpen(StructuredViewer.java:1131)
      at org.eclipse.ui.navigator.CommonViewer.handleOpen(CommonViewer.java:462)
      at org.eclipse.jface.viewers.StructuredViewer$6.handleOpen(StructuredViewer.java:1235)
      at org.eclipse.jface.util.OpenStrategy.fireOpenEvent(OpenStrategy.java:264)
      at org.eclipse.jface.util.OpenStrategy.access$2(OpenStrategy.java:258)
      at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:298)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
      at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)
      at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
      at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
      at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
      at org.talend.rcp.intro.Application.start(Application.java:159)
      at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)
      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
      at org.eclipse.equinox.launcher.Main.run(Main.java:1407)
      at org.eclipse.equinox.launcher.Main.main(Main.java:1383)
Caused by: java.sql.SQLException: Échec de l'ouverture de session de l'utilisateur 'dhonore'.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
      at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
      at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
      at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
      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:168)
      ... 60 more

My parameters:
login : my windows username
password : my windows password
server: my server name
port: 143
database: testdb
Additional parameters: instance=SQLEXPRESS
connexion string = jdbc:jtds:sqlserver://QONSEILSI1:1433/testdb;instance=SQLEXPRESS
Any ideas?
How I can investigate this issue?

Re: Setup a SQL Server connexion

Anonymous — Wed, 15 Oct 2014 06:33:43 GMT

Hi,
Make sure your login name and password are correct. Can you connect to your sql server by client without using Talend Tool?
Best regards
Sabrina

Re: Setup a SQL Server connexion

Anonymous — Wed, 15 Oct 2014 08:02:37 GMT

yes, I can

Re: Setup a SQL Server connexion

Anonymous — Wed, 15 Oct 2014 08:18:38 GMT

Hi,

login : my windows username
password : my windows password
server: my server name
port: 143
database: testdb
Additional parameters: instance=SQLEXPRESS
connexion string = jdbc:jtds:sqlserver://QONSEILSI1:1433/testdb;instance=SQLEXPRESS
Any ideas?
How I can investigate this issue?

Could you please try to use port: 1433 to see if it is working?
Have you checked document TalendHelpCenteretting up a database connection?

Best regards
Sabrina

Re: Setup a SQL Server connexion

Anonymous — Wed, 15 Oct 2014 09:01:14 GMT

Sorry, it is a mistake.
I use the port 1433

Re: Setup a SQL Server connexion

Anonymous — Wed, 15 Oct 2014 09:13:19 GMT

Hi,
Please remove double quote "" from dhonore to see if it is Ok with you?
Best regards
Sabrina

Re: Setup a SQL Server connexion

Anonymous — Wed, 15 Oct 2014 09:20:36 GMT

Same error

Re: Setup a SQL Server connexion

Anonymous — Wed, 15 Oct 2014 09:41:34 GMT

Hi,
What's your sql server version? 2014?
Have you checked document TalendHelpCenterupported systems and databases?
Could you please indicate talend build version you are using so that we can take a testing for you.
Best regards
Sabrina

Re: Setup a SQL Server connexion

Anonymous — Wed, 15 Oct 2014 13:36:48 GMT

Microsoft SQL Server Management Studio                        12.0.2000.8
Outils clients Microsoft Analysis Services                        12.0.2000.8
Microsoft Data Access Components (MDAC)                        6.3.9600.16384
Microsoft MSXML                        3.0 6.0
Microsoft Internet Explorer                        9.11.9600.17278
Microsoft .NET Framework                        4.0.30319.34014
Système d'exploitation                        6.3.9600
suppoerted version:

MS SQL Server

2000/2003/2005/2008/2012

Windows + Linux

so it should be Ok

"Talend Open Studio for Data Integration"
Version: 5.5.1
Build id: r118616-20140617-1110

Re: Setup a SQL Server connexion

Anonymous — Thu, 16 Oct 2014 05:16:25 GMT

Hi,
Is your SQL Server installed in your local machine? Have you tried to use "localhost" instead of your server name? Any "Schema" connection information is needed? Have you tried the Sql Server authentication mode?
Best regards
Sabrina

topic Re: Setup a SQL Server connexion in Talend Studio

Setup a SQL Server connexion

Re: Setup a SQL Server connexion

Re: Setup a SQL Server connexion

Re: Setup a SQL Server connexion

Re: Setup a SQL Server connexion

Re: Setup a SQL Server connexion

Re: Setup a SQL Server connexion

Re: Setup a SQL Server connexion

Re: Setup a SQL Server connexion

Re: Setup a SQL Server connexion