You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » MS SQL Server connection in TRUSTED mode
#1 2009-05-12 16:17:28
- pled76
- New member
- Registered: 2009-05-12
- Posts: 2
MS SQL Server connection in TRUSTED mode
Cannot establish MS SQL Server (2005, EXPRESS) connection in trusted mode (username/password are to be used from Windows user).
SQL authorization works well (checked).
JDTS driver supports trusted connection (checked in Pentaho BI with JDTS connection to the same server).
Please, check the software constraints and generated connection string to fix this bug in TOS 3.1 (3.0 also has the bug -- checked).
Thanks a lot in advance.
Offline
#2 2009-05-12 16:22:15
Re: MS SQL Server connection in TRUSTED mode
Hello guy
Can you try the tJDBCConnection component using JDTS driver and check if it is successful?
Let me know your test result.
Best regards
shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#3 2009-05-15 11:27:37
- pled76
- New member
- Registered: 2009-05-12
- Posts: 2
Re: MS SQL Server connection in TRUSTED mode
General JDBC
jdbc:jdts://localhost;instance=SQLEXPRESS;databaseName=FastDataMart;
...\Talend\TOS-All-r24382-V3.1.0\lib\java\jtds-1.2.jar
net.sourceforge.jtds.jdbc.Driver
Connect succefull.
But cannot retrieve schema for this connection (tried with no mapping, MSSQL mapping and MySQL mapping -- the result is jus "ERROR" with no other text).
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » MS SQL Server connection in TRUSTED mode