You are not logged in.
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?
(Talend 3.2M1 on Win. XP SP3)
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
You also need to change your server setting since named instances for JDBC are not recognized by the format "server"/"instance"
Additional Parameters: instance=RHODES
Last edited by briansms (2009-11-17 12:52:23)
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.