You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » [resolved] SQLServer Connection
#1 2009-11-06 18:57:08
- 34.50
- Member
- Registered: 2009-06-24
- Posts: 14
[resolved] SQLServer Connection
I'm trying to create metadata for a SQL Server 2005 connection, and it keeps failing. I can ping the server from this machine, so that's all fine. Basically when I hit check button, it says, "Connection Failure, you must check database settings." I click on details and it says, "Login failed for user 'abc'. The user is not associated with a trusted SQL Server connection."
I have the SQL server setup to accept remote connections through TCP/IP, and I can use the SQL Server client to connect to the SQL Server DB. Does anyone know what the problem is?
Thanks!
(Talend 3.2M1 on Win. XP SP3)
Respect my authoritahhhhh!!!!!!!!!!!1!!!
Offline
#3 2009-11-12 23:12:58
- Mel Haynes Jr
- Guest
Re: [resolved] SQLServer Connection
What type of authentication does the database allow? ( SQL Server, Windows Authorization, both )
If you are trying to authenticate using windows authorization, you will have to provide some additional parameters. Talend uses JDBC to connect to a database ( jDTS driver I believe ).
If you are connecting using SQL Server Authorization, could you provide a screenshot? Maybe that would help
#4 2009-11-13 16:01:27
- 34.50
- Member
- Registered: 2009-06-24
- Posts: 14
Re: [resolved] SQLServer Connection
The database allows both, but I'm trying to set it up using a SQL server login, and it's not working.
http://i34.tinypic.com/k5j7k.jpg
Respect my authoritahhhhh!!!!!!!!!!!1!!!
Offline
#6 2009-11-17 12:51:59
- briansms
- Member
- Company: SMS
- Registered: 2008-05-21
- Posts: 84
Re: [resolved] SQLServer Connection
You also need to change your server setting since named instances for JDBC are not recognized by the format "server"/"instance"
Server: RHODES
Additional Parameters: instance=RHODES
Last edited by briansms (2009-11-17 12:52:23)
Offline
#8 2011-10-27 11:48:55
- Shalinideepak
- Guest
Re: [resolved] SQLServer Connection
I m getting the same error which says 'Connection failure. You must change the Database Settings.
Login failed for user 'uk\sdeepak'.
I have given the correct server and database names and still no luck.Would appreciate if someone can help me quickly to get past this error.
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » [resolved] SQLServer Connection